Why is the DATETIME Format Not Consistent in My Destination?

NOTE: This article also applies to the MariaDB connector.

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 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 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.