Why Are TIMESTAMP Columns Inferred as TEXT in My Destination?

Use Case

Fivetran infers TIMESTAMP columns as TEXT.

Environment

File connectors

Answer

We infer TIMESTAMP values as TEXT if they are not in one of the following formats:

• LOCALDATETIME (yyyy-MM-dd-HH-mm-ss.zzz)
• LOCALDATE (yyyy-MM-dd)
• INSTANT (yyyy-MM-ddTHH:mm:ssZ)

For more information about the different date and time formats, see Oracle's Java Date-Time API documentation.

Cause

The value of the TIMESTAMP column is not in the correct format.