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.