Forum Discussion

DerekBaker's avatar
DerekBaker
Frequent Visitor
2 years ago

Fabric Warehouse Modify schema without dropping and recreating tables

I am wondering the best path for iteratively developing a Fabric Warehouse.  Typically, I am having to add a field on a table and because the ALTER table statement is not currently supported, I must ...
data warehouse
warehouse
frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years ago

DerekBaker have you tried dropping and recreating the table, and checked if the relationship is still there or if it needs to be recreated?

 

I have experienced some times that relationships persist even if they shouldn't logically be there anymore. https://community.fabric.microsoft.com/t5/General-Discussion/Dropping-and-recreating-lakehouse-table/m-p/3831977/highlight/true#M6257

 

If they do get dropped, perhaps you can recreate them in code by applying constraints on the new table. Otherwise I guess you will need to do it in the user interface...

 

I agree, not being able to alter tables sounds like something that can create a lot of extra work when having semantic models, shortcuts and other downstream dependencies.