Question

In the new connector, timestamp columns are created as TIMESTAMP_NTZ(9). In the old connector, it is created as TIMESTAMP_TZ(9). 

Environment

Connector: MySQL Database

Answer

There are two options to resolve this issue:

Option 1 - Keep timestamps for the new connector as TIMESTAMP_TZ

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

Option 2 - Keep timestamps for the old connector as TIMESTAMP_NTZ

1. Drop table in your data warehouse
2. Fivetran will sync the datetime columns as TIMESTAMP_NTZ

Cause

The inconsistency in timestamp data type is due to a change in October 2019. Any Connectors created prior to Oct 2019, would be created with "TIMESTAMP_TZ". All new Connectors (post-October 2019) would be created with "TIMESTAMP_NTZ".  You can read our changelog for more details.