How to check/list the tables which has CDF enabled?
Options
- 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 trueAlso, 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?