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 ways you can achieve 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 the 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.