Tonic Structural release information

Learn about what’s in the latest Tonic.ai product releases.
v1397
April 2, 2025

PostgreSQL - Fixed a regression in v1391 where Postgis extension types were not processed properly.

Oracle - Enhanced performance and memory usage while working with Oracle CLOB data.

Databricks - For a Databricks workspace, you can now specify a list of source schemas to include. When you specify multiple source schemas, Structural automatically creates the same schemas in the destination database.

Databricks - Fixed issues to allow Databricks workspaces to function when the user does not have access to all of the tables in the source schema.

v1398
April 2, 2025

Bug fixes and other internal updates.

v1396
April 1, 2025

SQL Server - Added enhancements to more gracefully handle null characters in Plan Guide names by removing the null characters prior to creation in the destination database.

v1395
March 31, 2025

Fixed an issue where the optional Identity Provider ID field for single sign-on (SSO) was required to have a value.

v1394
March 27, 2025

Snowflake - Fixed an issue where subset targets that were specified using percentages resulted in unexpected subset sizes.

v1393
March 27, 2025

SQL Server - Fixed DROP script generation failures that can occur when linked servers exist and SQL_SERVER_SCRIPT_CROSS_DATABASE_REFERENCES=false.

v1392
March 26, 2025

Bug fixes and other internal updates.

v1391
March 26, 2025

Bug fixes and other internal updates.

v1390
March 26, 2025

Bug fixes and other internal updates.

v1389
March 25, 2025

Fixed an issue where the Timestamp Shift generator failed for string columns that contained non-default date formats.

v1388
March 24, 2025

Bug fixes and other internal updates.

v1387
March 23, 2025

Bug fixes and other internal updates.

v1384
March 21, 2025

Bug fixes and other internal updates.

v1386
March 21, 2025

Bug fixes and other internal updates.

v1385
March 21, 2025

Bug fixes and other internal updates.

v1382
March 20, 2025

Bug fixes and other internal updates.

v1383
March 20, 2025

Snowflake - Fixed support for integers that are outside of the range from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.

v1381
March 19, 2025

Bug fixes and other internal updates.

v1380
March 18, 2025

MySQL - You can now configure whether to provide your own destination database schema for workspaces.

v1379
March 15, 2025

Okta SSO on Structural Cloud - Structural Cloud organizations can now use Okta single sign-on (SSO) to manage their Structural users. On Admin Settings view, administrators complete the Structural configuration from the new Single Sign-On tab on the Access Management tab. Note that this initial release does not include support for group filtering.

v1378
March 14, 2025

File connector - Fixed an issue handling NullArray in Parquet files.

Amazon DynamoDB - Changed the default connection type from local to AWS. Removed the seeded localhost value from the local server field.

Workspace overrides of environment settings - On the workspace details view, the new Advanced Workspace Overrides section allows you to override environment setting values for that workspace. It includes the existing statistics seed setting, as well as settings for data generation performance and, where supported, whether to have Structural create the destination database schema.

v1377
March 13, 2025

SQL Server - Fixed an issue that caused data generation to fail when a DateTime value was unable to be parsed.

v1376
March 12, 2025

Bug fixes and other internal updates.

v1375
March 11, 2025

Custom generator presets and sensitivity rules are now available with the Professional license plan. They no longer require the Enterprise license plan.

File connector - Addressed several user interface performance issues by caching and sharing schema information across API calls.

MySQL - The Data Pipeline V2 generation process is now enabled for MySQL. On the Confirm Generation panel, you can now choose whether to use the new process.

MySQL - The Data Pipeline V2 flow now supports subsetting.

v1374
March 7, 2025

Bug fixes and other internal updates.

v1373
March 6, 2025

File connector - Fixed an issue where file connector group prefixes would overlap if one prefix was a substring of another except for a trailing delimiter.

MySQL - MySQL now supports the Data Pipeline V2 flow.

v1371
March 5, 2025

Structural sensitivity detection for dates now ignores updated_at columns.

v1372
March 5, 2025

Bug fixes and other internal updates.

v1370
March 3, 2025

Bug fixes and other internal updates.

v1369
February 28, 2025

MySQL - Fixed an issue where jobs failed because of a warning about using a password on the command line or in the schema file.

v1368
February 28, 2025

Amazon DynamoDB data connector - The beta version of the DynamoDB data connector is now available.

v1367
February 27, 2025

Fixed an issue that sometimes caused OutOfMemory exceptions in the web server when a worker that was generating data produced a large volume of logs very quickly.

v1366
February 25, 2025

The new environment setting TONIC_FILE_SAMPLE_PARALLELISM allows Structural to sample multiple files concurrently at the expense of memory usage by the scan. The default value is 4.

v1365
February 25, 2025

Databricks - Fixed statistics error when applying and viewing Categorical and Continuous generators.

v1363
February 24, 2025

Bug fixes and other internal updates.

v1364
February 24, 2025

Bug fixes and other internal updates.

v1362
February 19, 2025

Bug fixes and other internal updates.

v1361
February 18, 2025

File connector - For Parquet files, fixed the support for applying generators to Decimal128 and Decimal256 columns.

v1360
February 14, 2025

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.

v1359
February 13, 2025

When Azure SSO is configured incorrectly, Structural now logs a warning instead of exiting.

v1358
February 13, 2025

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.

v1357
February 11, 2025

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

v1356
February 11, 2025

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.

v1355
February 7, 2025

Bug fixes and other internal updates.

v1354
February 5, 2025

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

v1353
February 5, 2025

Bug fixes and other internal updates.

v1352
February 3, 2025

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

v1351
January 30, 2025

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

v1350
January 28, 2025

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.

v1349
January 24, 2025

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.

v1348
January 23, 2025

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.

v1347
January 22, 2025

Bug fixes and other internal updates.

v1346
January 17, 2025

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

v1345
January 15, 2025

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

v1344
January 13, 2025

Bug fixes and other internal updates.

v1343
January 10, 2025

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.

v1342
January 9, 2025

Bug fixes and other internal updates.

v1341
January 8, 2025

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.

v1340
January 7, 2025

Salesforce - Resolved FIELD_INTEGRITY_EXCEPTIONs on OpportunityLineItem creation.

v1339
January 6, 2025

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.

v1338
January 3, 2025

Bug fixes and other internal updates.

v1337
January 2, 2025

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.

v1336
December 20, 2024

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.

v1335
December 19, 2024

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.

v1334
December 18, 2024

Bug fixes and other internal updates.

v1333
December 16, 2024

Databricks - Fixed an issue where the Struct Mask generator failed on array columns in Databricks 14.3+.

v1332
December 16, 2024

PostgreSQL - Fixed an issue where upsert failed for generated columns.

When you output destination data to Ephemeral or to a container repository, you can now configure the workspace to override the statistics seed.

v1331
December 13, 2024

Bug fixes and other internal updates.

v1329
December 11, 2024

From the Java SDK, you can now enable diagnostic logging when you generate statistics as part of processing a DataFrame.

Fixed an issue that caused the preview generated values to display incorrectly in the Database View generator recommendations.

v1330
December 11, 2024

Bug fixes and other internal updates.

v1328
December 10, 2024

Bug fixes and other internal updates.

v1327
December 6, 2024

Fixed Jobs hang when database connections (source or destination) are not available.

v1326
December 6, 2024

SQL Server - Added support for propagating non-system SQL CLR assemblies from the source to the destination.

v1325
December 5, 2024

Bug fixes and other internal updates.

v1324
December 2, 2024

Fixed an issue that caused the preview generated values to display incorrectly in the Database View generator recommendations.

v1323
December 2, 2024

MongoDB - Fixed an issue where specifying an unscanned collection as a subset target caused data generation to fail.

Salesforce - The Date Truncation generator now works correctly.

PostgreSQL - Fixed an issue where upsert operations failed on tables that contained custom types and unique constraints.

v1322
November 27, 2024

Bug fixes and other internal updates.

v1321
November 25, 2024

Bug fixes and other internal updates.

v1320
November 22, 2024

For Data Pipeline V2, fixed a rare issue where a job was not marked as failed after a fatal error, and the worker would not process other jobs.

Sensitivity confidence information in Privacy Hub - On Privacy Hub, the column boxes in the At-Risk Columns panel now reflect the confidence level in the sensitivity detection for each column. The sensitivity confidence is also displayed for the columns on the Recommended Generators by Sensitivity Type panel.

v1319
November 20, 2024

Bug fixes and other internal updates.

v1318
November 19, 2024

Bug fixes and other internal updates.

v1317
November 18, 2024

Fixed an issue where connection type limit in the Connection Type section of workspace settings was displayed incorrectly.

v1316
November 15, 2024

Bug fixes and other internal updates.

v1315
November 14, 2024

Fixed an issue where Microsoft Entra ID SSO groups were not retrieved if the membership in them was transitive.

v1314
November 13, 2024

Bug fixes and other internal updates.

v1313
November 12, 2024

Fixed an issue where PostgreSQL container artifacts failed to generate.

v1312
November 12, 2024

You can now specify the port that dotnet-monitor listens on within a worker. To set the port, use the environment setting TONIC_WORKER_DOTNET_MONITOR_PORT. Workers that are colocated on the same instance should be assigned different port bindings.

File connector - For custom Amazon S3 URLs, you can now indicate to trust the server certificate. To configure this, use the TONIC_AWS_S3_TRUST_SERVER_CERT environment setting.

MongoDB - Fixed an issue that caused layout problems for Privacy Hub.

v1311
November 10, 2024

Snowflake - Fixed an issue where a worker would sometimes become unresponsive after cancelling a data generation job.

Google BigQuery - Improved progress tracking for tearing down and recreating entities in the destination dataset.

v1310
November 8, 2024

Databricks - For new workspaces, changed the default Databricks runtime to 14.3.x-scala2.12.

v1309
November 6, 2024

When you configure a workspace to write output to a container repository, you can now provide a custom password for the destination database superuser.

v1308
November 5, 2024

File connector - The file upload now restricts accepted files to those that have supported file extensions.

v1307
November 1, 2024

MySQL - Improved resilience to transient issues when applying table constraints.

v1306
October 31, 2024

Fixed an issue where the first recommendation in the Recommended Generators by Sensitivity Type panel was cut off.

Fixed an issue where the generator recommendation preview sometimes failed with the message No Workspaces have been created yet.

v1305
October 30, 2024

Added API endpoints to enable and disable subsetting for a workspace.

v1304
October 29, 2024

Database View redesign and sensitivity confidence - On Database View, the Applied Generator column is now split into two columns. The Status column shows the current sensitivity status (Not Sensitive, At Risk, or Protected). From the Status column, you can display information about the detected sensitivity type and configure whether the column is sensitive. For at risk columns, the Status column also indicates the confidence level in the sensitivity detection. The Applied Generator column indicates the current generator assignment and allows you update the generator configuration.

Improved the detection accuracy for values in defined categories, such as gender.

Added the option to collect performance metrics when starting a data generation job that uses the Data Pipeline V2 processing.

v1303
October 27, 2024

When you write output to a container repository, you can now use assumed roles for the AWS credentials for Amazon ECR.

v1302
October 24, 2024

Snowflake - Improved performance when loading workspaces that connect to large databases.

v1300
October 24, 2024

Fixed an issue that caused the job details view to crash for some jobs that had warnings.

v1301
October 24, 2024

Bug fixes and other internal updates.

v1299
October 23, 2024

Added a new configuration setting TONIC_SENSITIVITY_SCAN_IGNORE_PII_TYPES. Accepts a comma-separated list of sensitivity type identifiers that the sensitivity scan should ignore.