Snowflake Component Release Notes

DI-6683: The Positional File Processing property has been added to the Load file to Snowflake template to support positional files.

DI-9413: Added the ability to change the timeout of the Snowpipe getStatusReport process.

DI-9275: Fixed an issue which stopped columns from being set to boolean type.

DI-9060: Add support for binary data types.

DI-7983: Add delimiters around object names in generated queries when they contain reserved characters.

DI-8808: Fix component dependencies.

DI-8183: Upgrade third-party library.

DI-8113: Load Rdbms to Snowflake: incorrect file path generated when using s3 as external storage

DI-8286: Third-Party library upgrade.

DI-7766: Snowflake JDBC driver Third-Party library upgrade.

DI-6683: The Positional File Processing property has been added to the Load file to Snowflake template to support positional files.

DI-6578: In the Load Rdbms to Snowflake template, when the String Delimiter option is enabled, the mapping fails to compile.

DI-1093: The Load External Storage File to Snowflake template is now available for loading files already present in an external storage into a target Snowflake table.

DI-5015: Designing and reading JSON data contained in a VARIANT column is now supported.

DI-6197: Snowflake JDBC driver upgraded to version 3.13.22.

DI-6224: The Replicator Rdbms to Snowflake tool is now available. This tool can be used to replicate data to Snwoflake using Snowpipe.

DI-6235: Google Cloud is now supported as an external storage location.

DI-6301: The Storage Access Method parameter has been added to the metadata. It allows defining the method to use to access the external storage: using credentials or using storage integration defined in Snowflake.

DI-6341: The Snowpipe finger tab has been added to the metadata. Snowpipe allows ingesting data files from Snowflake stages directly into Snowflake tables without having to launch the warehouse.

DI-5029: Some error messages returned by the Load Wsdl to Rdbms template may not be relevant in finding the cause of the error.

DI-6683: Template Load file to Snowflake: add the Positional File Processing property to support positional files.

DI-6578: Template Load RDBMS to Snowflake: when the String Delimiter option is enabled, the mapping does not compile.

DI-6262: The technology definition has been updated to mention that indexes are not supported. Thus, the generic templates do not try to create indexes on this database.

DI-5015: Support designing and reading JSON data contained in a VARIANT column.

DI-5029: When being used with Snowflake as a target, error messages returned by "Load Wsdl to Rdbms Template" might not be relevant to find the real cause of the error.

DI-6197: Update the Snowflake JDBC driver third-party library to version 3.13.22.

DI-4508: Update Components and Designer to take into account dedicated license permissions

DI-4731: Rebranding: Template messages

DI-4962: Improved component dependencies and requirements management

DI-5014: Support QUALIFY clause in Snowflake

DI-4855: Support "Technical Columns Prefix" on Reject and Integration Templates

DI-4849: Snowflake - add support for additional timestamp types

DI-4404: Snowflake - all work tables are now created as transient

DI-2854: Microsoft Azure Storage and Amazon S3 Bucket nodes available in the workspace are now proposed automatically in Snowflake Metadata in External Storage attribute

DI-2696: Snowflake - full outer joins were not working

DI-2741: Template - LOAD Rdbms to Snowflake - generated temporary file names may unexpectedly contain object delimiters

DI-1056: Addition of a new Process Tool which allows to perform operations on a Snowflake Warehouse, such as starting or suspending a warehouse

DI-1910: Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet

DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking

DI-1554: Load Rdbms to Snowflake Template - an exception was displayed when loading data through S3 storage, because the Module specification on S3 step was missing, avoiding the step to properly find the required dependencies

DI-1908: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates on Lock / Unlock CDC steps

DI-1907: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates when querying the source data