Enabling enableChangeDataFeed on Streaming Table created in DLT

Vsleg
Contributor

Hello, 

Can I enable Change Data Feed on Streaming Tables? How should I do this? I couldn't find this in the existing documentation https://learn.microsoft.com/en-us/azure/databricks/delta/delta-change-data-feed .

Hello Kaniz,

I already tried this ALTER TABLE but it doesn’t work for Streaming Table creating inside a DLT pipeline.

Vsleg
Contributor

I got this error and tried CREATE OR REFRESH as well but that didn't work either..

Vsleg_0-1710420802041.png

 

Vsleg
Contributor

john77
New Contributor II

I have noticed the same issue.

saurabh18cs
Honored Contributor III

Hi @Vsleg i think you cannot enable cdf like this for streaming tables. it is not natively supported for DLT streaming tables , please have a look here = Propagating Deletes: Managing Data Removal using D... - Databricks Community - 90978