topic Delete on warehouse table timed out in Data Warehouse

Delete on warehouse table timed out

cw88 — Mon, 07 Aug 2023 14:41:05 GMT

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] select * from [basetable]

The statements are executes via script activity in a data pipeline

In most cases the statements ran in timeout error "Operation on target delete destination table failed: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

A select on DMV sys.dm_exec_requests shows wait type "EDC_EXEC" (?) , also after getting the timeout error...

Re: Delete on warehouse table timed out

Anonymous — Wed, 09 Aug 2023 16:53:40 GMT

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

Re: Delete on warehouse table timed out

cw88 — Wed, 09 Aug 2023 04:33:13 GMT

Hi,

truncate is not supported in warehouse, or is there any news?

Re: Delete on warehouse table timed out

Anonymous — Wed, 09 Aug 2023 16:54:45 GMT

My bad I have updated my comment if you can help to provide more info.

Regards

Geetha

Re: Delete on warehouse table timed out

mikeburek — Wed, 21 May 2025 19:17:49 GMT

Just to close out this question if anyone lands on it, the TRUNCATE command was added to the Fabric Warehouse in Aug 2024: