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.

     

     

PradeepOS's avatar
PradeepOS
Regular Visitor
2 years ago

MSFT Fabric now has a solution to rename delta table columns.

 

Run this code in a Fabric notebook:

 


ALTER TABLE <table_name> SET TBLPROPERTIES (
   'delta.columnMapping.mode' = 'name',
   'delta.minReaderVersion' = '2',
   'delta.minWriterVersion' = '5')
 
and then run the rename query:
 
ALTER TABLE <table_name> RENAME COLUMN <old_name> TO <new_name>
AndyDDC's avatar
AndyDDC
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Careful with this though as if you set the table to name mapping mode, table changes won't be synced to the Lakehouse SQL Endpoint