Truncate Warehouse SQL table

[BiJoe]

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 the correct manner. I have tried TRUNCATE TABLE <table name> in the pre-copy script inside the copy activity, and a separate Script activity in the pipeline with same query in the "Non-query" script field. Either way I get "TRUNCATE TABLE is not a supported statement type." 

What am I missing here?

EDIT: A DROP TABLE <table name> statement works in the Script activity. So it's just the TRUNCATE statement not supported yet?

[TwinkleCyril]

We are working on adding support for TRUNCATE TABLE in Fabric DW and will be available soon. Stay tuned!

[TwinkleCyril]

TRUNCATE Table is now generally available in Fabric DW. Review TRUNCATE TABLE (Transact-SQL) - SQL Server | Microsoft Learn for further details.

[NandanHegde · Accepted solution]

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/