DataSync for Snowflake Release Notes

Fix for processing message and improperly pushing to error queue.

Extend column to max size if content is larger than current size. Requires the extendColumnsMaxLength configuration.

Log which column is being truncated when insert/update a record into Snowflake and the data is too large for the column. Requires the truncateColumns configuration.

Fix for Numeric value 'true' is not recognized , Numeric value 'false' is not recognized error when translating boolean values for newly adding custom columns using the translateBooleans configuration.

Fix to truncate text if its over a column's length and log if record fails being inserted/updated in Snowflake.

Fields such as password can now be encrypted for the meshlet using the meshlet install script.

Snowflake DataSync meshlet now supports the mapping of Boolean type to Number.

When quotedColumns is configured to false, adding columns in ServiceNow will now get reflected in Snowflake. 

You can now add custom columns in your Snowflake tables with configuring the databasesConfig.json file. To read more information, see add custom fields.

Snowflake meshlet now supports using table compare.

Snowflake meshlet now supports local schema files.

Snowflake meshlet now supports using Microsoft Azure as an external stage for bulk loading. 

Snowflake meshlet supports soft deletes (updating fields to indicate the record is deleted and leaving the record intact in the database table).

Meshlets now support reading multibyte_encrypted messages.

Snowflake meshlet recovers by recreating the table when the table is dropped while the Meshlet is running and processing messages.

Specifying the maximum string size for the entire collection is available through maxStringSize key. See Meshlet Configurations for Snowflake.

Adding parameters to your connectionUrl to leverage other forms of authentication is available through useConnectionProperties key. See Meshlet Configurations for Snowflake.