Why Are TIMESTAMP Columns Inferred as TEXT in My Destination?

Use Caselink

Fivetran infers TIMESTAMP columns as TEXT.

Environmentlink

File connectors

Answerlink

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.

Causelink

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