Forum Discussion

Community Champion

2 years ago

ALTER TABLE DW

I have been trying to use ALTER Table Alter Column on a data warehouse table but it does not sem to be supported. I have a table that has a column a column [row_sum] [bigint] NULL I want to c...

data warehouse

warehouse

AndyDDC

Most Valuable Professional

2 years ago

Hi smpa01 currently you can only add new columns to an existing table. This is because MS are using an older version of the Delta Lake read/write protocol. There's no info yet when further support for ALTER TABLE will be supported.

I have more info in this blog https://www.serverlesssql.com/the-reality-of-alter-table-in-fabric-warehouses-2/

smpa01

Community Champion

2 years ago

This is simply not practical.

MS must inform this community when can we expect this to happen?

Till it happens what are the alternatives?

Theses gotchas keep on preventing any serious data-engineering in Fabric.

It is simply not possible to simply DELETE a table with valuable data to alter a single column type, imagine the nightmare of the fabric developer if this sort of req keeps coming frequently from business every now and then. How do I deal with it in absence of ALTER?

Forum Discussion

ALTER TABLE DW

Related content

Using Field Parameters to Alter My Table Visual Content

SQL ALTER command

Fabric DW from SQL server

Data Warehouse Alter Table add default value constraint

DW Missing features compared to SQL server