Delete on warehouse table timed out

[cw88]

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

[mikeburek]

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

• https://www.reddit.com/r/MicrosoftFabric/comments/1er251b/fabric_warehouse_now_supports_truncate/
• https://www.youtube.com/watch?v=NB_iZ0sqgn0
• https://www.c-sharpcorner.com/article/new-in-fabric-warehouse-sql-truncate/

[GeethaT-MSFT]

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

[cw88]

Hi, 

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

[GeethaT-MSFT]

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

Regards

Geetha