In the new connector, timestamp columns are created as TIMESTAMP_NTZ(9). In the old connector, it is created as TIMESTAMP_TZ(9).
Connector - MySQL Database
There are two options to resolve this issue:
Option 1 - Keep timestamps for the new connector as TIMESTAMP_TZ
- Alter the column data type to TIMESTAMP_TZ
- Fivetran will sync the datetime columns as TIMESTAMP_TZ
Option 2 - Keep timestamps for the old connector as TIMESTAMP_NTZ
- Drop table in your data warehouse
- Fivetran will sync the datetime columns as TIMESTAMP_NTZ
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.