Issue
Timestamp columns in the source application are inferred as String values in the warehouse as opposed to Timestamp.
Environment
File Connectors
Resolution
The Timestamp column value needs to be in one of the following 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 Java's Documentation.
Cause
The column datetime or timestamp value is not in the correct format.