How to Fix False Out of Sync on Timestamp Column Being Null on Snowflake - DSS 6 | Data Source Solutions Documentation 5 Documentation
Documentation: How to Fix False Out of Sync on Timestamp Column Being Null on Snowflake - DSS 6 | Data Source Solutions Documentation 5 Documentation
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
DSS 6 Location: Snowflake
Resolution
Add an environment action for the target with the below information:
- Name: DSS_SNOWFLAKE_ODBC_USE_CUSTOM_SQL_DATA_TYPES
- Value:
FALSE - Context: compare
Use this context for Compare.
Cause
This parameter DSS_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.