If the table(s) do not have a primary key, we offer an option to sync it using the Custom Primary Key feature.
Prerequisite:
The table must have a unique key using NOT NULL columns. The unique key will work as the primary key for sync.
This will only be set on the destination for Integrate.io ELT & CDC Sync.
Getting Started
1. Modify the column of your table to set a custom PK
![undefined](https://cdn.buttercms.com/byMzYTCqSR6Xjf7QsgXA)
2. Select a column(s) that has a unique key and is NOT NULL.
![undefined](https://cdn.buttercms.com/rXlkUjER89UDq2hV8beA)
3. Once selected, hit Save
![undefined](https://cdn.buttercms.com/GdPostC2TBuiaUk2gOiw)
4. Click Continue to Sync Settings to start the replication.
![undefined](https://cdn.buttercms.com/tcr1TP8Tu2cf33fwOntE)