Nava Gross

01/31/2022, 8:22 PM
Hi 👋, Just playing around with airbyte and we set up a connector between an sql server db and bigqquery. When setting up which tables to sync in airbytes, some of the tables have the options for incremental sync and some only have full refresh. They are all coming from the same db and we enabled changed detection on all the tables as well, so there is no apparent different between tables on the sql side. Is there something I'm missing?
👀 1

Augustin Lafanechere (Airbyte)

02/01/2022, 3:26 PM
Hi @Nava Gross, incremental is removed from available sync modes if the table does not have a primary key. Do your tables all have a primary key defined?

Nava Gross

02/02/2022, 8:29 AM
😅 that was the issue, two of the tables were missing primary keys. Thanks!