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.