Data loss in Airbyte connection from Snowflake to PostgreSQL

Summary

Data loss issue observed when transferring 36 lakhs records from Snowflake to PostgreSQL, where only 34 lakhs records are visible in the destination. Seeking solution.


Question

Hello folks,
I am creating an airbyte connection, with source as snowflake and destination as postgresql, I am working with 36 lakhs records but in destination I am able to see 34 lakhs records. I am unable to understand why the data loss is happening. Can anyone suggest me a solution?



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

["data-loss", "airbyte-connection", "snowflake", "postgresql"]