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

1. Alter the column data type to TIMESTAMP_TZ
2. Fivetran will sync the DateTime columns as TIMESTAMP_TZ

Option 2 - Change timestamps for the old connector to TIMESTAMP_NTZ

1. Drop table in your data warehouse
2. 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.