How to Fix False Out of Sync on Timestamp Column Being Null on Snowflake

Issue

Compare shows as out of sync on a table with timestamp columns to Snowflake target. The diff file shows that it thinks the target timestamp column is null, but querying the data on target shows that the data is in sync.

Environment

HVR 6 Location: Snowflake

Resolution

Add an environment action for the target with the below information:

• Name: HVR_SNOWFLAKE_ODBC_USE_CUSTOM_SQL_DATA_TYPES
• Value: FALSE
• Context: compare

Use this context for Compare.

Cause

This parameter HVR_SNOWFLAKE_ODBC_USE_CUSTOM_SQL_DATA_TYPES is added to support time zone regions in Snowflake. The default setting of TRUE works for replication but causes issues for Compare for certain customers. This affects 6.1.0/xx versions.