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

[User16826994223 · Accepted solution]

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)