Data Insert for Snowflake
Our Data Insert Wizard allows you to upload Excel or CSV files to your data warehouse without the need for S3 / Blob storage intermediary. New in Aginity 21.12, Snowflake is now among the platforms supported for this streamlined process. Aginity also supports bulk data load for Snowflake and Redshift.
Save Tab into the Catalog
Aginity’s Catalog functions as an analytics repository to store curated SQL scripts and other analytics code for reuse. Catalog assets can be referenced as objects within other scripts to increase analytic consistency. Aginity Premium extends catalog functionality further with role-based governance and shared and/or scheduling of catalog assets.
You can right-click on any code selection within the query editor to save it to your catalog, but we wanted to provide another option to support additional workflows. Starting in this release, right-clicking on a tab in Aginity’s query editor will present you with a new option to save the tab’s content to your catalog. Try it out!
As you know, we’re always working hard to expand database object support, autocomplete, and DDL coverage within our supported database platforms. Here’s what’s new in this release:
- BigQuery – Materialized Views
- Postgres – Exclude Constraints
- New drivers for Snowflake, Azure SQL, Azure Synapse, SQL Server, Hive, DB2
The following capabilities are available in the latest release of Aginity Premium:
- Files – users will now be able to work with their desktop files in our server deployed Premium
- Log distinction – administrators will be able to better distinguish between application and infrastructure logs.
As always, this release also includes a number of bug fixes and application performance improvements.
Until next time… Query on!