data changed in DATE columns when transferrring from Snowflake to Postgres #39392
Unanswered
martinfuchsobi
asked this question in
Connector Questions
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I perceived a very strange behaviour when transferring data from Snowflake to Postgres.
We just start using airbyte and in order to answer to an internal customer's request I built a connection from our (prod) snowflake system to a test postgres instance.
everything firstseemed be run fine, but then I detected that DATE values in the destination were one day before the corresponding value in Snowflake, for example:
I have a row like 20240610, 2024-06-10 in the snowflake source, data types are NUMBER(9,0) and DATE
the transferred row looks like 20240610, 2024-06-09 in the postgres destination
has anyone encountered similar problems ?
Beta Was this translation helpful? Give feedback.
All reactions