Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Lakehouse Add or Remove columns from table

Not sure if this is the right forum or not - but here is the issue.   We are loading data to a Lakehouse using gen 2 data flows (for now they are just pointing at exisitn gen 1 dataflows then doi...
Dataflows
frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years ago

It seems to be possible to add columns in Lakehouse table now by using notebook.

 

I am able to use the following type of command in a Notebook:

 

%%sql

ALTER TABLE tableName

ADD COLUMN columnName dataType

 

And the table will get updated also in SQL Analytics Endpoint and Direct Lake Semantic Model, something which was a problem before.

 

Ref. this thread:

https://community.fabric.microsoft.com/t5/General-Discussion/SQL-ALTER-command/m-p/3748079#M4861

 

However, I get an error if I try to rename or remove (drop) a column.