Question
Timestamp columns in the source application are inferred as string values in the warehouse as opposed to Timestamp.
Environment
Connector: File Connectors
Answer
The timestamp column value needs to be in one of LocalDateTime
, LocalDate
or Instant
formats:
- yyyy-MM-dd-HH-mm-ss.zzz
- yyyy-MM-dd
- yyyy-MM-ddTHH:mm:ssZ
More information on these formats can be found in the Java documentation.
Cause
The column datetime
or timestamp
value is not in the correct format.
Comments
0 comments
Please sign in to leave a comment.