Tonic Structural release information

MongoDB - Fixed an issue where applying the Categorical generator to a document database column could result in an error.

Custom generator presets and sensitivity rules on Structural Cloud - On Structural Cloud, you can now configure custom generator presets and custom sensitivity rules. The presets and rules that you configure are only available to your organization. The Account Admin permission set is now granted permission to configure custom generator presets and custom sensitivity rules.

Salesforce - Added logic to set BusinessHours reference field values to valid destination values for scratch orgs.

Salesforce - Added additional destination constraint lifting logic to prevent FIELD_FILTER_VALIDATION_EXCEPTION and DUPLICATES_DETECTED errors.

MongoDB - Fixed an issue where applying the Categorical generator to a document database column could result in an error.

Updates to Table View - On Table View, the column headings now display icons to identify the protection status and the detection confidence level for each column. It also indicates when there is a recommended generator, and allows you to apply the recommendation to the column.

Bug fixes and other internal updates.

The UUID Key generator now supports UUIDs that are stored in strings without hyphens. When the input value contains hyphens, the output contain hyphens. When the input value does not contain hyphens, the output does not contain hyphens.

MySQL - Improved resilience to certain issues while processing tables.

Salesforce - Added additional destination constraint lifting logic to prevent FIELD_FILTER_VALIDATION_EXCEPTION and DUPLICATES_DETECTED errors.

MySQL - Fixed an issue where data generation would hang after the destination database crashed.

Bug fixes and other internal updates.

Google BigQuery - Added basic support for the BigQuery RECORD type.

Structural no longer supports Docker engines that are older than 20.10.9.

Added an optional parameter, preserveExistingTags, to the workspace import API endpoint. When true, the tags in the imported workspace file do not overwrite the existing tags in the target workspace for the import. The default behavior is to overwrite the existing tags with the tags from the imported file.

Before an upsert job, Structural now performs constraint validation on the destination table. This avoids potential upsert failures because of missing uniqueness or primary key constraints as well as violations of foreign key constraints for downstream tables.

Fixed an issue where some columns found by custom sensitivity rules could not be marked as not sensitive.

Sharing Structural logs with Tonic.ai is changed from opt-in to opt-out. Log sharing is now enabled by default. To disable log sharing, set the environment setting ENABLE_LOG_COLLECTION to false on all Structural containers.

Bug fixes and other internal updates.

MySQL - Improved resilience to certain issues during constraint application and processing tables.

MySQL - Fixed an issue with long-lived destination database connections.

Using secrets managers for database passwords - With the new secrets manager feature, Enterprise users can now opt to retrieve database passwords from AWS Secrets Manager. On Structural Settings view, you configure the available secrets managers. On the workspace details, to use a secrets manager for the database password, you select an available secrets manager and the secret to use from that secrets manager.

Salesforce - Resolved FIELD_INTEGRITY_EXCEPTIONs on OpportunityLineItem creation.

Bug fixes and other internal updates.

Snowflake - Fixed an issue where temporary files in the cloud storage provider were not deleted when a job was canceled.

SQL Server - Fixed an issue where Structural processed SPROC object re-creation when TONIC_SQL_SERVER_SKIP_CREATE_DB=true.

SQL Server - Fixed an issue on older versions of SQL Server where the error UnknownPropertyException (NetName) was thrown.

For upsert, improved the error handling. Instead of failing the upsert job when a single table fails, do a try/catch of issues with warnings.

Fixed an issue where the Database View filters initially displayed no content.

Oracle - Fixed an issue where automatic sensitivity scans on workspaces that exceeded the job timeout were reported as failed instead of canceled.

Bug fixes and other internal updates.

The generator configuration for the HIPAA Address generator no longer suggests linking address types that cannot be linked. You can no longer link the Address and HIPAA Address generators.

PostgreSQL - Fixed an issue where upsert failed with a bad insert statement.

To prevent upsert failures, improved the schema check to include comparisons of primary keys, unique columns, foreign key constraints, and indexed columns in the source and destination databases.

Bug fixes and other internal updates.

Fixed an issue introduced in v1332 where the dropdown for selecting a user when transferring a workspace or assigning a global permission set would not close upon selection.

Added a new environment setting TONIC_ENABLE_JAVA_SDK_DOWNLOAD that controls whether to allow downloads of the Java SDK. The default value is true.

Fixed an issue where users who had permission to view destination data, but did not have permission to view source data, were able to use composite generators to view unmasked data.