Why Do Excel DATE Columns Sync as TIMESTAMP_TZ in SharePoint?

Question

Why are DATE columns from my Excel source file stored as TIMESTAMP_TZ in the destination, and how can I retain them as DATE?

Environment

Connector: SharePoint

Answer

By default, when syncing Excel files with Fivetran file connectors, columns formatted as DATE in Excel are converted to TIMESTAMP_TZ in the destination. This is expected because Excel stores date values as date-time objects, and the connector interprets them accordingly.

If you need these columns to remain DATE, contact Fivetran Support and request enabling the connector option/flag to preserve DATE types. After Support enables it, drop the affected table(s) and run a full resync to apply the updated type to existing data.