Edit on GitHub
Why is the DATETIME Format Not Consistent in My Destination?link
NOTE: This article also applies to the MariaDB connector.
Questionlink
Why is my MySQL connector syncing inconsistent DATETIME formats to my destination?
Environmentlink
Connector: MySQL or MariaDB
Answerlink
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.