How to check/list the tables which has CDF enabled?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ01-31-2023 09:38 AM
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?
- Labels:
-
CDF
-
Tables
-
TBLPROPERTIES
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ01-31-2023 11:10 AM
Just wrap it in Python code, add .collect() in the end of listTables and apply for each
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ02-23-2023 02:46 PM
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.

