I've enabled CDC on my SQL Server db and tables. I...
# ask-community-for-troubleshooting
y
I've enabled CDC on my SQL Server db and tables. I'm using airbyte to load it into Snowflake. Is there a way I can have the replication be faster than every 5 minutes? Also the Sync mode is only showing me Full refresh | Append. I don't see the incremental option for source anymore even though my airbyte data source(SQL server) was configured for CDC
Specifically I'm referring to this: https://airbyte.com/blog/what-is-data-replication#:~:text=As%20we%20have%20seen%20before%2C%20log[…]20near%20real%2Dtime%20data%20replication.%C2%A0 It sounds like using CDC with Airbyte you should be able to replicate at a faster rate than the fastest batch rate which is every 5 mins.