Capabilities for Snowflake

This section lists the Capabilities of Data Source Solutions DSS when using 'Snowflake'. For more information about the pre-requisites, access privileges, and other configuration requirements, see Snowflake Requirements.

Capture

DSS does not support Capture changes from location on Snowflake.

Repository Database

DSS does not support Repository database on Snowflake.

Integrate

DSS supports the following capabilities on Snowflake:

• Integrate changes into location (Snowflake version 2.8).
• Burst integration (Integrate with parameter Method=BURST) (Snowflake version 2.8).
• Append integration into TimeKey (Integrate with parameter Method=APPEND) (Snowflake version 2.8).
• Integrate with parameter BurstCommitFrequency (Snowflake version 2.8).
• Continuous integration (Integrate with parameter Method=CONTINUOUS) (Snowflake version 2.8).
• ColumnProperties with parameter SoftDelete (Snowflake version 2.8).
• Bulk load requires a staging area (location property Staging_Directory) (Snowflake version 2.8).
• Creation and update of DSS state tables (Snowflake version 2.8).

DSS does not support the following capabilities on Snowflake:

• Tables without a key and without TableProperties with NoDuplicateRows for continuous integration.
• Continuous integrate with parameter OnErrorSaveFailed.
• Disable/enable database triggers during integrate (with parameter NoTriggerFiring).
• Integrate with parameter DbProc.

Bi-directional Replication

DSS does not support Bi-directional Replication on Snowflake.

Refresh and Compare

DSS supports the following capabilities on Snowflake:

• dssrefresh or dsscompare from source location (Snowflake version 2.8).
• dssrefresh into target location (Snowflake version 2.8).
• Isolated table dssrefresh (option -i) into target location (Snowflake version 2.8).
• Row-wise dssrefresh into target location (option -g) (Snowflake version 2.8).
• Identity columns (Snowflake version 2.8).

Other Capabilities

DSS supports the following capabilities on Snowflake:

• Call database procedure dbproc during replication jobs (AgentPlugin with parameter DbProc) (Snowflake version 2.8).
• International table and column names where DBMS is not configured with UTF-8 encoding (Snowflake version 2.8).
• Treat DBMS table names and columns as case sensitive if configured (location property Case_Sensitive_Names) (Snowflake version 2.8).
• Treat DBMS schema names as case sensitive if configured (location property Case_Sensitive_Names) (Snowflake version 2.8).

DSS does not support the following capabilities on Snowflake:

• Use distribution key for parallelizing changes within a table (ColumnProperties with parameter DistributionKey).