Log in
New Document View option to configure file connector JSON columns - For JSON file connector columns, instead of the JSON Mask generator, you can use the new Document View option to view the JSON structure and to assign generators to each combination of path and data type within the JSON. On the column configuration panel for a file connector JSON column, toggle Use Document View to the on position. Document View displays as a new tab on the workspace management view.
On the recommended generator panel for columns, fixed an issue where the preview data was not generated.
SQL Server - The TONIC_SQL_SERVER_SCRIPT_NO_FILE_GROUPS configuration setting is now respected when creating constraints in the destination database.
SQL Server - Improved column length mismatch handling for SQL Server bulk copy.
File connector - On self-hosted instances, you can now configure a file mount as the source for file connector workspace files. After you set up the file mount, to enable the file mount option, you configure the file mount path as the value of the environment setting TONIC_FILE_MOUNT_POINT. For a file mount workspace, you can write the output to Amazon S3 or back to the file mount. Similar to cloud storage workspaces, you can select files or folders, and filter the file types to include.
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.