Forum Discussion

BiJoe's avatar
BiJoe
Helper II
2 years ago
Solved

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?

3 Replies