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?
Connector: SQL Server
There are two ways you can achieve this:
Option 1: Change timestamps for the new connector to TIMESTAMP_TZ
- Alter the column data type to
- Fivetran will sync the DateTime columns as
Option 2: Change timestamps for the old connector to TIMESTAMP_NTZ
- Drop the table in your data warehouse
Fivetran will sync the
Note: This option will result in an accumulation of MAR for the whole table.
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
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.