Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
BiJoe
Helper II
Helper II

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 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?

1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

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/

View solution in original post

3 REPLIES 3
TwinkleCyril
Microsoft Employee
Microsoft Employee

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.

NandanHegde
Super User
Super User

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/

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.