How to check/list the tables which has CDF enabled?

[Databrickguy]

How to list all the tables which has CDF enabled?

I can review a table to find out if CDF is enable with below code.

SHOW TBLPROPERTIES tableA(delta.enableChangeDataFeed)

The return

 
key                                                                    value
delta.enableChangeDataFeed                       true

Also, below code can list all the tables in databaseA

spark.catalog.listTables("databaseA")

How can I combine both to list all the tables which has delta.enableChangeDataFeed=== true?

[Hubert-Dudek]

Just wrap it in Python code, add .collect() in the end of listTables and apply for each

[jose_gonzalez]

Hhi @Tim zhang​,

Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.