Question
A newly created SQL connector has synced DateTime columns as TIMESTAMP_NTZ. But in the old connector, it is TIMESTAMP_TZ. How can these be made the same for both connectors?
Environment
Connector: SQL Server
Answer
There are two options to do this:
Option 1 - Change timestamps for the new connector to TIMESTAMP_TZ
- Alter the column data type to TIMESTAMP_TZ
- Fivetran will sync the DateTime columns as TIMESTAMP_TZ
Option 2 - Change timestamps for the old connector to TIMESTAMP_NTZ
- Drop table in your data warehouse
- Fivetran will sync the DateTime columns as TIMESTAMP_NTZ
Note: This option will result in an accumulation of MAR for the whole table.
Cause
The inconsistency is due to a change in March 2020. Any Connectors created prior to this date would have been created with "TIMESTAMP_TZ". All new Connectors (post-March 2020) are created with "TIMESTAMP_NTZ".
Note: If you have an old connector and added any new table to sync recently, then the old tables will have TIMESTAMP_TZ and the new table will have TIMESTAMP_NTZ. For the data type to be consistent across all tables, please contact Fivetran support.