Forum Discussion
Alter Table in Fabric
Hi Anonymous ,
I am not using any external tools.We have a redudant column on a table which needs to be dropped.Executing ALTER TABLE...DROP COLUMN is erroring out.
Now this table is being referenced in the semantic model and we are not sure if dropping the table and recreating it with the necessary columns would break the existing model.
Hi SachinNandanwar,
OK, I test these operations on my side, and they also be blocked due to the limits. For your scenario, perhaps you can try to remove the not need columns at the 'data ingestion' steps.
Regards,
Xiaoxin Sheng
For the time being we would send default values to the column. I came to know that ADD column statement works with the ALTER TABLE but not the DROP column .
Any tentative timelines when this feature would be available ?HI SachinNandanwar,
I check on the official document and blog but not found they mention this. I'd like to suggest you focus on the follow link that listed the fabric data warehouse feature release plan:
Regards,
Xiaoxin Sheng
SachinNandanwar please vote for this idea to support DROP COLUMN in Fabric Data Warehouse:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=5cf6f63e-9d5b-ef11-b4ad-6045bdbf73f2
