Edit on GitHub
Why Are TIMESTAMP Columns Inferred as TEXT in My Destination?link
Use Caselink
Fivetran infers TIMESTAMP columns as TEXT.
Environmentlink
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.