Forum Discussion
BiJoe
Helper II
Helper IITruncate 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/
TwinkleCyril
Microsoft Employee
Microsoft EmployeeWe are working on adding support for TRUNCATE TABLE in Fabric DW and will be available soon. Stay tuned!
TwinkleCyrilMicrosoft Employee
Microsoft EmployeeTRUNCATE Table is now generally available in Fabric DW. Review TRUNCATE TABLE (Transact-SQL) - SQL Server | Microsoft Learn for further details.