How can I run ```ALTER TABLE lt table gt SET TBLPROPERTIES d

Question

How can I run ```ALTER TABLE lt table gt SET TBLPROPERTIES delta enableChangeDataFeed = true ``` On a delta table outside of a databricks runtime via a spark shell I don t use databricks

Tom van Bussel · Answer

Yes you can just run `spark sql ALTER TABLE ` in Spark Shell

Simon Thelin · Answer

but how do I point to the actual table

Simon Thelin · Answer

because register it as a view is not right here

Simon Thelin · Answer

should I add location

Tom van Bussel · Answer

```ALTER TABLE delta `<scheme path to table>` SET TBLPROPERTIES delta enableChangeDataFeed = true ```

Simon Thelin · Answer

okay I tried ```ALTER TABLE s3a ```

Simon Thelin · Answer

or wait I did not use ```````

Tom van Bussel · Answer

Spark uses ```format `path````

Simon Thelin · Answer

< Tom van Bussel> thanks so much I could not find this in the delta docs for CDF

Simon Thelin · Answer

will try this now

Simon Thelin · Answer

Okay It does not work but I might be doing something incorrectly I tried ```spark sql ALTER VIEW `scheme ` SET TBLPROPERTIES delta enableChangeDataFeed = true ``` And ```spark sql ALTER VIEW `` SET TBLPROPERTIES delta enableChangeDataFeed = true ```

Simon Thelin · Answer

but that did not work thinking face

Simon Thelin · Answer

omg nvm I am high

Tom van Bussel · Answer

Yeah it s more of a Spark thing than it is a Delta thing but we do use it in some examples in the docs

Tom van Bussel · Answer

ALTER TABLE not ALTER VIEW

Simon Thelin · Answer

Yeah I was too stressed Still does not seem to work thinking face ```spark sql ALTER TABLE `s3a lt bucket gt lt path gt lt table name gt ` SET TBLPROPERTIES delta enableChangeDataFeed = true ``` ```spark sql ALTER TABLE `scheme s3a lt bucket gt lt path gt lt table name gt ` SET TBLPROPERTIES delta enableChangeDataFeed = true ``` ```+ UnresolvedTable lt path gt lt table name gt ALTER TABLE SET TBLPROPERTIES Please use ALTER VIEW instead ``` Strange

Simon Thelin · Answer

I know I have permissions because I can read the table vanilla DeltaTable or vanilla spark read style

Simon Thelin · Answer

the table has a dash in the name that might be why

Simon Thelin · Answer

`table 1234` This table was originally created by trino

Tom van Bussel · Answer

It needs to be ```spark sql ALTER TABLE delta `s3a lt bucket gt lt path gt lt table name gt ` SET TBLPROPERTIES delta enableChangeDataFeed = true ```

Simon Thelin · Answer

Success wow this is awesome < Tom van Bussel> Thanks that worked

Tom van Bussel · Answer

+1

Simon Thelin · Answer

We are doing some wild stuff with delta table created by trino enabling CDF for a downstream CDF app eyes trino adds a random id in S3 but when queried via metastore it looks like it does not have the random id so was worried this would cause trouble but since you just point to the full path in s3 it does not matter