Database Filtering in Discovery
Several months ago we released the ability to create saved filters for your database connections. This is useful when you want to focus on just a subset of connections and/or database objects. Our Discovery Assistant has now been updated to honor any currently active filter. This makes it pain-free to navigate directly to the target object within the Database Object Tree.
Inserting column name/value from Results grid into a query
Here’s a quick tip: Pressing the spacebar after selecting an object in the Database Object Browser will automatically insert that object name into the query editor. This under-the-radar functionality has been around for a while, but in version 21.7, we’ve expanded this pattern to work with any column or row value selected in the results grid. Hitting the space bar after selecting either a results column header or row value cell will now insert that name/value into the query editor. This is helpful when refining a query from an initial “Select *”.
More useful error messages
IBM Db2 is known for its cryptic error messages. Loved by those who have memorized hundreds of common error codes, but annoying for the rest of us. We feel your pain… Aginity will now do the lookup for you and return Db2 error messages with human-readable descriptions. We hope this will speed up your troubleshooting efforts!
We’ve also improved error messages related to Data Upload (Bulk Upload & Data Insert). In addition to reflecting the success/failure status of each data upload task, the Job Monitor now presents helpful details about any errors which may have been encountered.
We’re always working hard to expand our deep database support — object, autocomplete and DDL coverage — for our supported platforms. Here’s what we’ve added with version 21.7:
- Greenplum – Unique Keys, Distributed by, User Defined Data Types, Domains,
- Postgres – Unique Keys, User Defined Data Types, Domains, System Data Types
- Redshift – System Data Types
Aginity Premium & Enterprise
Schedule your demo of Aginity Premium to see how this collaborative analytics platform expands the functionality of Aginity Pro with capabilities such as pivoting and charting query results, query scheduling, and, most significantly, a shared analytics catalog with granular permissions to connect data engineers and analysts.
During your demo, we can also show off some additional functionality included in our latest release of Aginity Premium & Enterprise, which includes:
- Active Directory configuration through UI –We know configuring syncing users with LDAP is hard, so admins now have a UI to do this.
- Email configuration – Admins can configure the email server on Aginity Premium so users can receive external notifications.
- OAuth with Snowflake – admins will now be able to configure Connection Templates to support OAuth authentication for their users
Until next time…. Query on!