Release Notes Incorta 2024.1.6

Release Highlights

This maintenance pack introduces the following new features:

• Enhancements to the data extraction via Public API
• 2 new query functions that can be used in variables and In-Query filters
• Enhanced UX of insight and tab downloads

What’s New

• Data Extraction via Public API enhancements
• Support for querying data with limits in variables and In-Query filters
• Enhanced UX of insight and tab downloads

Data Extraction via Public API enhancements

The Delete External Table endpoint now supports deleting related Parquet files and the target path with the external table definition. Additionally, you can enforce the deletion of external tables and their files when deleting the parent external schema.

• Set the purge option to true in the Delete External Table endpoint to delete the target path and Parquet files related to the given external table, along with the external table definition in the Spark Metastore.
• Set the cascade option to true in the Delete External Schema endpoint to delete the target paths and Parquet files related to the external tables in the given external schema, along with their definitions in the Spark Metastore.

Enhanced querying with limits in variables and In-Query filters

In this release, Incorta introduces two query functions designed for efficient data retrieval when working with internal session variables, global variables, and In-Query filters. These functions enable you to specify a limit on the number of records returned, allowing more targeted querying based on defined conditions.

• queryWithLimit: Returns a specified number of records from a given column, with the option to apply additional filters to further narrow down the results.
• queryDistinctWithLimit: Returns a limited set of unique (distinct) values from a specified column, with the ability to apply filters to refine the selection of distinct values.

Enhanced UX of insight and tab downloads

When downloading an insight or a dashboard tab, a notification will be displayed indicating the preparation for the download as well as the download process. You can dismiss the notification, and the download will continue, or you can cancel the download.

Enhancements