Forum Discussion
Solved
Truncate Warehouse SQL table
I have a working pipeline, pulling data from API, and using a Copy activity to load the data into a SQL table in Warehouse. I would like to truncate the rows before copying, but I can't seem to find ...
Hey,
Truncate statement is yet not supported in warehouse for now.
You can use Delete statement/
https://joyfulcraftsmen.com/exploring-limitations-of-fabric-warehouse-3-key-observations/
We are working on adding support for TRUNCATE TABLE in Fabric DW and will be available soon. Stay tuned!
TRUNCATE Table is now generally available in Fabric DW. Review TRUNCATE TABLE (Transact-SQL) - SQL Server | Microsoft Learn for further details.