Summary
After selecting primary keys during the Airbyte source replication step, the destination tables in PostgreSQL and Snowflake did not have the primary keys assigned. Various update methods and sync modes were tested without success.
Question
Hello!
• I did some tests on Airbyte - I selected the primary keys during the Airbyte source replication step. Following the sync operation, the source data tables were replicated to the destination database with all the values and datatypes intact. However, the primary keys were not assigned to the destination tables. This process was attempted with both PostgreSQL and Snowflake selected as the destination database. Various Update Methods were tried, including:
◦ Read Changes using Write-Ahead Log (CDC)
◦ Detect Changes with Xmin System Column
◦ Scan Changes with User Defined Cursor
◦ Additionally, all sync modes were tested.
Any guidance or assistance you can provide on resolving this issue would be greatly appreciated.
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.