Hi Team -
I'm a first time poster. I want to rep...
# ask-community-for-troubleshootingh
Heather Sheridan
06/06/2022, 3:31 PMHi Team -
I'm a first time poster. I want to replicate data between Microsoft SQL Server to Snowflake. I've successfully done this on one database so far. I applied change-data-capture (CDC) to the new database I want to replicate and have 3 tables with CDC enabled. When I get to the replication screen, I don't see anything except 'dtproperties' as a table option. I should see 3 tables. Is there something I'm missing?
Heather Sheridan
06/06/2022, 5:48 PMI found the culprit. I hadn't granted the login/user permission to select from the cdc tables in the database. Thanks to anyone peeking at this!
👍 1
m
Marcos Marx (Airbyte)
06/07/2022, 12:21 PMAwesome @Heather Sheridan!