topic Re: Truncate Warehouse SQL table in Pipelines

Truncate Warehouse SQL table

BiJoe — Wed, 03 Jan 2024 12:51:12 GMT

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?

Re: Truncate Warehouse SQL table

NandanHegde — Thu, 04 Jan 2024 04:18:08 GMT

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/

Re: Truncate Warehouse SQL table

TwinkleCyril — Tue, 02 Jul 2024 05:50:36 GMT

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

Re: Truncate Warehouse SQL table

TwinkleCyril — Sat, 10 Aug 2024 05:16:23 GMT

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