V1154 - latest

A new entry is added each week, and contains the release notes for all of the Tonic Structural versions that were released during that week.

V1162 - V1166

April 26, 2024

Added a new API endpoint to resolve all schema changes in a workspace. You can choose whether to resolve only conflicting changes, only notifications, or all of the schema changes.

Fixed an issue that caused the Tonic Structural PyML Service to be unreachable in IPV4-only containers.

Added a new conflicting schema change when a column that has an assigned generator becomes a foreign key. Foreign key columns must inherit the generator from the primary key.

Structural can now generate data with subsetting when a primary key table is truncated, as long as the foreign keys that reference the primary key are nullable.

Amazon Redshift

• Added support to pass through varbyte, geometry, and hllsketch types.

File connector

• For CSV, XML, and JSON files, fixed issues with the data preview in Database View and Table View. The preview no longer includes extra rows, and the preview now correctly reflects the Skip first N rows setting.

• Fixed the validation of file groups that only contained compressed files.

Snowflake

• For subsetting, added support for virtual foreign keys.

SQL Server

• Fixed an issue that caused data generations to fail for versions of SQL Server older than SQL Server 2016.

V1154 - V1161

April 19, 2024

For the notifications image, replaced alpine with ubuntu.

File connector

• For a local files workspace, the job details view for a successful data generation now includes an option to download the transformed files that were produced by that job.

• For workspaces that use files from cloud storage, you can now include prefix patterns in the file group definition. You can also provide file extension filters. The file group then includes all of the files that match a prefix pattern and the file extension filters. The file group details now include the content type, file extension filter, and prefix patterns.

• For cloud storage workspaces, users who do not have permission to view all buckets can once again specify the bucket to view.

• For cloud storage workspaces, added a configuration option to only process new files during data generation. For existing file groups, the new configuration is off by default. For new file groups, the configuration is enabled by default.

MongoDB

• Fixed an issue where environment setting updates from the UI required a restart to take effect.

MySQL

• For a workspace that is configured to write output to Ephemeral, you can now provide a custom configuration file.

Snowflake

• Fixed an issue where the Subsetting tab disappeared after you edited a workspace.

SQL Server

• For versions 2017, 2019, and 2022, you can now configure workspaces to write output to a container repository.