Snowflake Component Release Notes
This page lists the main features added to the Snowflake Component.
Change Log
Version 2023.3.0
Feature improvements
-
DI-6430: Replicator Snowflake: add the
splitFileSize
parameter. -
DI-6604: Add
BINARY
,OBJECT
,ARRAY
,GEOGRAPHY
,GEOMETRY
,VARBINARY
data types in the Snowflake technology. -
DI-6628: Snowflake: implement TargetFilter.
-
DI-6640: Add DESERIALIZER Snowflake String as JSON Template.
-
DI-6641: Add DESERIALIZER Snowflake VARIANT as XML Template.
-
DI-7182: Replicator Rdbms to Snowflake: Add
timestampFormat
parameter to choose the format and precision of the timestamp columns. -
DI-7183: Replicator Rdbms to Snowflake: Add
emptyFieldAsNull
andnullValueReplacement
parameters. -
DI-7623: Update templates using S3 features to use the existing AWS S3 TOOL instead of dedicated code.
-
DI-7767: Add MERGE incremental method to Snowflake Integration template.
-
DI-7983: Add delimiters around objects name in the generated queries when they contain reserved characters.
-
DI-7992: New template Load JSON to Snowflake.
Bug fixes
-
DI-7180: Replicator Rdbms to Snowflake: incorrect execution condition generated when using Snowpipe with some technologies.
-
DI-7305: SQL Server datatypes with maximum size such as
varchar(max)
should be reverse engineered as returned by the JDBC Driver, and themax
keyword specified only at datatype creation. -
DI-8040: In the reverse wizard, the list of schemas proposed is unexpectedly not filtered based on the selected catalog.
Version 2023.1.14
Version 2023.1.10
Version 2023.1.0
Feature improvements
-
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.
Version 5.3.12 (Component Pack)
Version 5.3.7 (Component Pack)
Version 2.0.2 (Snowflake Component)
Feature improvements
-
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
Bug fixes
-
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