Coginiti menu Coginiti menu

Coginiti 24.12 Release Notes 

Matthew Mullins
December 17, 2024

 We’re thrilled to announce the latest updates in Coginiti 24.12! This release brings powerful new features, expanded capabilities, and performance enhancements to help your team work smarter and faster.  

New Features and Capabilities

CoginitiScript Iceberg Table Materialization  

Expanding on our support for Apache Iceberg as an open table format. Gain seamless integration with major query engines and platforms, as CoginitiScript now supports Iceberg tables as publication strategy for materializing data on Amazon Athena, Google BigQuery, Trino, and Starburst  

#+src sql Sales() 
#+meta {
   :publication {     
   :type "table",
   :name "sales",
   :athena {
     :iceberg {
         :location "s3://foo/sales/",
         :format "parquet",
         :compression "snappy",
         :partitioning ["col1", "col2"]
       }
     }
   }
 }
#+begin
#+end

CoginitiScript Runtime Environments

Project owners can now specify the runtime environments for CoginitiScript projects and select which one should be used as a default. When opening any asset from the given project Coginiti will automatically select a connection and apply overrides specified for the selected environment. When a project environment is selected, the color of the tab will be set to color of the connection used for that environment as Coginiti does now when selecting connections directly.

Project manifest file has been extended with following:

  • environment section to TOML file where user can specify which environment to use as default
  • add ability to define any number of named environments with connection information
[environment]
   default = "dev"
[environment.dev]
   name = "Development"
   connection = { name="My Connection", overrides={ schema="dev" } }
[environment.prod]
   name = "Production"
   connection = { name="My Connection", overrides={ schema="prod" } }

In the example above environment.dev is defining an environment with following properties:

  • ID of the environment is “dev”
  • Name of the environment is “Development”
  • Connection to use is “My Connection” (referenced by name from the list of connections) with ability to specify overrides as key/value pairs (overrides are platform specific).

Yellowbrick DDL Support

  Build and manage Yellowbrick database objects effortlessly with support for:  

  •   Tables  
  •   Views  
  •   Sequences
  •   Procedures  

AI Assistant Enhancements

  Leverage cutting-edge language models with added support for:  

  •   Google Gemini Fast and Pro Models  
  •   Anthropic Claude 3.5 Haiku Model

These new models bring improved context understanding, advanced suggestions, and seamless collaboration with your data.  

Project Review Enhancements 

Inline commenting is now available in project review, enabling clearer communication and collaboration within your team. Users can also import and export Project Hub artifacts and version history.

Public Preview of HybridQuery for Snowflake

Coginiti’s HybridQuery for Snowflake introduces a transformative way to query Iceberg tables without relying on Snowflake’s internal Virtual Warehouses. Key features include:  

  • Optimized Workflows: Users can write Snowflake SQL just as they normally would when working with Snowflake tables.  
  • Cost-Efficiency: Offload Iceberg queries from Snowflake’s compute resources, reducing costs. 
  • Caching: Coginiti caches the most recent datasets, up to 1.8GB, for faster access and improved performance.  

Security Enhancements and Bug Fixes 

We’ve continued to refine and enhance the platform’s security to protect your data and workflows. This release also includes fixes to known issues to ensure a smoother experience.