topic Re: How to check/list the tables which has CDF enabled? in Data Engineering

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

Databrickguy — Tue, 31 Jan 2023 17:38:37 GMT

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?

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

Hubert-Dudek — Tue, 31 Jan 2023 19:10:44 GMT

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

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

jose_gonzalez — Thu, 23 Feb 2023 22:46:27 GMT

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.