Why is the DATETIME Format Not Consistent in My Destination?

Question

Why is my MySQL connector syncing inconsistent DATETIME formats to my destination?

Environment

Connector: MySQL or MariaDB

Answer

The inconsistency in DATETIME formats is due to a change on October 2019. Any connections created before October 2019 sync DATETIME data to the destination as TIMESTAMP_TZ values. Any connections 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 format

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

Switch to TIMESTAMP_NTZ format

1. Drop the existing table in your destination.
2. Re-sync the table in your Fivetran dashboard. Fivetran will now sync all of the DATETIME columns as TIMESTAMP_NTZ.