Enable change data feed , is it available automatically or it has to be enabled manually

User16826994223
Databricks Employee
Databricks Employee
 

User16826994223
Databricks Employee
Databricks Employee

ou must explicitly enable the change data feed option using one of the following methods:

  • New table: Set the table property  delta.enableChangeDataFeed = true in the 

CREATE TABLE command.

CREATE TABLE student (id INT, name STRING, age INT) TBLPROPERTIES (delta.enableChangeDataFeed = true)

Any existing table

ALTER TABLE myDeltaTable SET TBLPROPERTIES (delta.enableChangeDataFeed = true)

View solution in original post