Forum Discussion

ebjim's avatar
ebjim
Resolver 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.

     

     

AndyDDC's avatar
AndyDDC
Most Valuable Professional
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.

 

 

mjc-fabric's avatar
mjc-fabric
Frequent Visitor
2 years ago

Can you provide more information on how to use a notebook to add a column to a lakehouse table?

 

I am using a Dataflow Gen2 to get data from SQL Server into the lakehouse. Do you know if that is a delta table?