Hi,
When I look at guides for enabling CDF (Change Data Feed), they all use SQL commands like ALTER TABLE to enable it. I'm using path based tables for now, and can't get that to work. Is there python syntax for setting the required property on a table as well? Or is there a way to use SQL commands against path based tables, that I'm not aware of?
n
Nick Karpov
01/10/2023, 5:15 PM
you should be able to reference path based table by prepending
delta
like so:
Copy code
ALTER TABLE delta.`/path/to/my/table` SET TBLPROPERTIES (delta.enableChangeDataFeed = true);
👍 2
g
Geir I
01/11/2023, 8:28 AM
Thanks a lot 👍 Somehow, I missed the required delta prefix.