Release Notes Incorta Cloud 2024.1.2
Release Highlights
In this maintenance pack:
Derived tables’ support for key columns
Now, you can specify key columns for Incorta Analyzer and SQL tables. Adding, removing, or changing key columns does not require running a load job, as derived tables are refreshed as part of schema update jobs. The derived table’s unique index is calculated and saved as a snapshot DDM file each time the key columns are updated or the schema or table is loaded.
Ensure that the column or columns you designate as key maintain row uniqueness because no deduplication is performed for derived tables. If the selected key columns result in duplicate key values:
- During the schema update job, duplicate values are kept, and the Engine will return the first matching value whenever a single value of the key columns is required. The schema update logs will point out the unique index issue.
- During the schema or table load job, the unique index calculation will fail, resulting in a finished-with-error load job. No value is returned when the unique index is required. You must select the correct key columns to have the unique index calculated.
Enhancements
| Enhancement | Area |
|---|---|
| Advanced SQL Interface is now available by default. You can enable it from the cloud admin portal without contacting Incorta Support. | Advanced SQLi |
| The default value of the Insight Max Groups UI Default option in the CMC > Tenant Configurations > Advanced has been adjusted to 500 million, down from 1 billion, to improve the overall system performance and prevent excessive resource usage during the calculation of a large number of group dimension values. Notes: ● If you have changed the value of this property before, the set value will be maintained; otherwise, the default value will be adjusted automatically. ● This adjustment might affect insights that exceed the specified group count and do not have a configuration set at the insight level. | CMC |