Forum Discussion
smpa01
Community Champion
Community ChampionALTER 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...
AndyDDC
Most Valuable Professional
Most Valuable ProfessionalHi 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/