Capabilities for Snowflake

Last updated on Jan 05, 2021

Contents

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

Capture

HVR does not support Capture changes from location on Snowflake.

Hub Database

HVR does not support Hub database on Snowflake.

Integrate

HVR supports the following capabilities on Snowflake:

  • Integrate changes into location (Snowflake version 2.8).
  • Integrate with /Burst (Snowflake version 2.8).
  • Integrate with /BurstCommitFrequency (Snowflake version 2.8).
  • Continuous integration (Integrate without /Burst) (Snowflake version 2.8).
  • Action Transform /SoftDelete (Snowflake version 2.8).
  • Bulk load requires a staging area (LocationProperties /StagingDirectoryHvr) (Snowflake version 2.8).
  • Creation and update of HVR state tables (Snowflake version 2.8).

HVR does not support the following capabilities on Snowflake:

  • Action TableProperties with /DuplicateRows for continuous integration.
  • Continuous Integrate with /OnErrorSaveFailed (without /Burst).
  • Disable/enable database triggers during Integrate (/NoTriggerFiring).
  • Integrate with /DbProc.

Bi-directional Replication

HVR does not support Bi-directional Replication on Snowflake.

Refresh and Compare

HVR supports the following capabilities on Snowflake:

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

Other Capabilities

HVR supports the following capabilities on Snowflake:

  • Call database procedure dbproc during replication jobs (action AgentPlugin /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 case sensitive (action LocationProperties /CaseSensitiveNames) (Snowflake version 2.8, since HVR 5.6.5/1).

HVR does not support the following capabilities on Snowflake:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey).
  • Lossless binary float datatypes. No dataloss when transporting float values (because base 2 fractions are never converted to base 10).