Can we setup CDC Tracking on a view or materialized view?

Question

Can we setup CDC Tracking on a view or materialized view? We are using confluent platform, source is SQL Server & CDC tool is debezium.

Hautegaronne

Not sure why this question has been closed. It's clear what's being asked (can you use CDC tracking on views or VMs in SQL Server). – Peen

Answer 1

Based on About Change Data Capture (SQL Server) you can only define CDC against tables themselves.

Change data capture records insert, update, and delete activity that is applied to a SQL Server table.

Peen

Thanks Robin, So we can't fetch data changes from a view in any condition? – Hautegaronne

@SamadAbbasi, unfortunately it’s impossible – Kangaroo

There won't be an actual error right, initial snapshot will show data but then changes won't be tracked – Devotional