Forum Discussion
cw88
Helper IV
Helper IVDelete on warehouse table timed out
Hi, i'm building a little warehouse and created some staging tables. Before loading data into these tables, i want to delete the table data. 1. Delete from [testtable] 2. Insert into [testtable] ...
Hi cw88
It seems like you are experiencing a timeout error while trying to delete data from a table before loading new data into it. This error can occur if the table is too large or if there are too many rows to delete.
How do you run the queries here?
If you use any client tool, increasing the timeout helps?
or,
I think providing a statement Id or / Ids might help
Regards
Geetha
cw88Helper IV
Helper IVHi,
truncate is not supported in warehouse, or is there any news?
My bad I have updated my comment if you can help to provide more info.
Regards
Geetha