Forum Discussion

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
2 years ago
Solved

Cannot DROP a table in a Fabric Warehouse

I have a table the had about 2 million rows of fact data. I needed to add a column but cannot simply run an ALTER TABLE statement. So I need to DROP the table and recreate it. Shouldn't be that hard.

 

But the DROP TABLE statement just hangs. 

I was able to do a DELETE FROM <my table> to remove all the rows just fine. The table is now empty. Still, the DROP TABLE statement does not complete. I let it run for 20 minutes.

I have removed it from the Default Semantic Model in the Warehouse. 

 

I don't know what else to do. I'm stuck. 

IMHO, Fabric is just not ready for prime time yet.

3 Replies

  • Anonymous Thanks, yeah, there was an INSERT statement blocking it. Not sure what from seeing as all jobs had been closed out/disconnected.

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi ToddChitt 
      Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.