Issue with CDC configuration in source-mssql connector for Airbyte

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is facing an issue with CDC configuration in the source-mssql connector for Airbyte. They have set up CDC at the database level and connected tables, but can only select full refresh in the Airbyte interface. They are using Airbyte version 0.59.1 and source-mssql-connector 4.1.1.


Question

Hello!
I need help with an issue. I used the search but couldn’t find any recent discussions.

I want to use CDC in source-mssql. I have configured CDC at the database level, connected the tables, and I can see changes in the db.cdc schema. However, in the Airbyte interface, I can only select full refresh for the table with CDC.
So, what am I doing wrong?

Airbyte mssql-source is configured as “Read Changes using CDC”, airbyte version is 0.59.1, source-mssql-connector - 4.1.1


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

["cdc-configuration", "source-mssql-connector", "airbyte", "full-refresh", "database-level", "cdc-schema"]
2

You might try Refresh source schema on Schema tab for connection

3

<@U05JENRCF7C> thank’s for reply!

i have tried, it doesn’t help)

4

For those who have encountered this issue and are looking for reasons - the problem is due to the missing PKs in the tables.