Forum Discussion

ebjim's avatar
ebjim
Icon for Resolver I rankResolver I
2 years ago
Solved

Renaming columns and adding columns

I have digging around for definitive answers but have not much to show for. I have read this   https://learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area#t-sql-surface-area and htt...
data engineering
data warehouse
one lake
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ebjim 
    Thanks for using Fabric Community.
    Yes you are right. Currently rename a table in lakehouse, and ALTER table functions, adding new columns in a Lakehouse table is not supported in Fabric.
    sp_rename is supported for Tables, Stored Procedures , Views and Functions in Warehouse. It is supported only for objects not for columns.

    Hope this helps. Please let me know if you have any further questions.

  • AndyDDC's avatar
    AndyDDC
    2 years ago

    You can change the schema of a lakehouse table by using a notebook and advancing the schema if your table is a delta table. The lakehouse sql endpoint won't let you do any schema (or data) modifications.

     

     

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.