Hi,

For the CDC on Materialised views, as the feature is in private preview at the moment you would need to speak to your account team to get it enabled. You also need to be using DBR 18.1 or above on classic compute for it to work.

The workaround would be to have the materialized view copied into a standard delta table and use this for the sync. But the snapshot approach may be the most efficient option.

Thanks,

Emma