Slackbot
05/26/2023, 8:43 AMkapa.ai
05/26/2023, 8:43 AMkapa.ai
05/26/2023, 8:44 AMtimestamp without timezone column in your Postgres source. The error message indicates that the provided date-time value is considered invalid. Airbyte has five temporal types: date, timestamp_with_timezone, timestamp_without_timezone, time_with_timezone, and time_without_timezone. These are represented as strings with specific format (either date or date-time) [source](https://docs.airbyte.com/understanding-airbyte/supported-data-types). However, JSON schema does not have a built-in way to indicate whether a field includes timezone information. To resolve this ambiguity, sources producing timestamp-ish fields should choose either timestamp_with_timezone or timestamp_without_timezone (or time with/without timezone) using the airbyte_type field [source](https://docs.airbyte.com/understanding-airbyte/supported-data-types). Please ensure that your source schema is correctly configured with the appropriate airbyte_type for your timestamp column. If you still encounter issues, consider checking the data in your source table to ensure that it conforms to the expected format.