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
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?
Solved! Go to 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/
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.
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/
User | Count |
---|---|
6 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
10 | |
7 | |
7 | |
6 |