Change Data Capture cannot be enabled on a table with a clustered columnstore index. Consider dropping clustered columnstore index

Question

I am getting the below error when trying to enable CDC on a table with a clustered columnstore index:

Change Data Capture cannot be enabled on a table with a clustered columnstore index. Consider dropping clustered columnstore index

But I need to have both CDC and clustered columnstore index on the same table.

Is there any workaround to this limitation?

Answer 1

The workaround to this is to enable CDC first and then to create a clustered columnstore index.

1. Drop a clustered columnstore index if exists.
2. Enable CDC.
3. Create a clustered columnstore index.

Voila! It works!