Forum Discussion
cw88
Helper IV
3 years agoDelete on warehouse table timed out
Hi, i'm building a little warehouse and created some staging tables. Before loading data into these tables, i want to delete the table data. 1. Delete from [testtable] 2. Insert into [testtable] ...
mikeburek
Advocate III
1 year agoJust to close out this question if anyone lands on it, the TRUNCATE command was added to the Fabric Warehouse in Aug 2024:
- https://www.reddit.com/r/MicrosoftFabric/comments/1er251b/fabric_warehouse_now_supports_truncate/
- https://www.youtube.com/watch?v=NB_iZ0sqgn0
- https://www.c-sharpcorner.com/article/new-in-fabric-warehouse-sql-truncate/