NOTE: This article also applies to the MariaDB connector.
Why is my MySQL connector syncing inconsistent DATETIME formats to my destination?
Connector: MySQL or MariaDB
The inconsistency in DATETIME formats is due to a change on October 2019. Any connectors created before October 2019 sync DATETIME data to the destination as TIMESTAMP_TZ values. Any connectors created after October 2019 sync DATETIME data as TIMESTAMP_NTZ values.
Choose one of the following methods to resolve this issue:
Keep using TIMESTAMP_TZ formatlink
- Alter the column data type to TIMESTAMP_TZ in your destination.
- Fivetran will now sync the datetime columns as TIMESTAMP_TZ.
Switch to TIMESTAMP_NTZ formatlink
- Drop the existing table in your destination.
- Re-sync the table in your Fivetran dashboard. Fivetran will now sync all of the DATETIME columns as TIMESTAMP_NTZ.