Forum Discussion
Data Warehouse Drop Column
The below blog provides explict details w.r.t alter table scenarios that are supported as of today in fabric warehouse and the limitations :
https://www.serverlesssql.com/the-reality-of-alter-table-in-fabric-warehouses-2/
Unfortunately , you would have to create a new table, sync the data to new table and drop the old table as the easy way around
The below blog provides explict details w.r.t alter table scenarios that are supported as of today in fabric warehouse and the limitations :
https://www.serverlesssql.com/the-reality-of-alter-table-in-fabric-warehouses-2/
Unfortunately , you would have to create a new table, sync the data to new table and drop the old table as the easy way around
Unfortunately, I suspected something like this. Thank you!
I also found a work around by remaking the columns with ADD COLUMN and just appending "_corrected" to the column name, then renaming it in a view. Not ideal but got the job done.