Handling -infinity timestamp values when syncing from Postgres to Snowflake

Summary

Issue encountered when syncing data from Postgres to Snowflake due to -infinity timestamp values. Seeking a solution to handle this problem.


Question

Hello all, I am using airbyte oss and am finding it is working well, however we have run into 1 issue with data types. We are syncing from postgres to Snowflake and found an issue with timestamp data types. in postgres we have values of -infinity that then error out when sent to snowflake as datetime types. is there a way to handle this? Thanks



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["handling--infinity-timestamp-values", "syncing-postgres-snowflake", "data-types", "timestamp", "airbyte-oss"]