Capabilities for Snowflake

This section lists the of Fivetran Local Data Processing when using 'Snowflake'. For more information about the pre-requisites, access privileges, and other configuration requirements, see .

Capture

Local Data Processing does not support changes from location on Snowflake.

Repository Database

Local Data Processing does not support Repository database on Snowflake.

Integrate

Local Data Processing supports the following capabilities on Snowflake:

• changes into location (Snowflake version 2.8).
• Burst integration ( with parameter Method=BURST) (Snowflake version 2.8).
• with parameter BurstCommitFrequency (Snowflake version 2.8).
• Continuous integration ( with parameter Method=CONTINUOUS) (Snowflake version 2.8).
• 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 Local Data Processing state tables (Snowflake version 2.8).

Local Data Processing does not support the following capabilities on Snowflake:

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

Bi-directional Replication

Local Data Processing does not support Bi-directional Replication on Snowflake.

Refresh and Compare

Local Data Processing supports the following capabilities on Snowflake:

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

Other Capabilities

Local Data Processing supports the following capabilities on Snowflake:

• Call database procedure dbproc during replication jobs ( 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).

Local Data Processing does not support the following capabilities on Snowflake:

• Use distribution key for parallelizing changes within a table ( with parameter DistributionKey).
• Lossless binary float datatypes. No data loss when transporting float values (because base 2 fractions are never converted to base 10). The values for these datatypes, when selected back from the database, might be slightly different from the ones that were inserted. This leads to Compare differences.