DataSync for Snowflake Release Notes

Add loadSchemasOnStart configuration to create table in Snowflake database from local schemas only when a record for the table is received.

Optimize to use SELECT LIMIT 1 statement as part of querying if table exists in Snowflake database prior to taking action.

Updated to use CREATE TABLE to prevent overwriting tables that already exists in Snowflake database and handle response if table exists to continue processing records. Added CREATE TABLE to databaseConfig.json configuration file to allow updating of configuration outside of meshlet.

Handle messages with empty or undefined value field without looping.

Support filtering messages to only read messages from one instance (key)

Support DB views to skip null values for the compound sys_id and order *_sys_id values in alphabetical order.

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

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 for processing message and improperly pushing to error queue.

Meshlets will only run with Java 11 and greater. 

Enable the purgeTable directive to truncate or delete all the records for a selected table in your database before bulk sharing. See Meshlet Configurations for Snowflake.