Forum Discussion
Abdul_Ismail
4 months agoRegular Visitor
Table UPDATE statements on the same Warehouse table.
I am using Microsoft Fabric Data Pipelines with a ForEach activity to run multiple UPDATE statements on the same Warehouse table. When multiple updates run at the same time, I get concurrency or...
- 4 months ago
Hi Abdul_Ismail,
Thank you tayloramy, for your insights.
This issue happens because parallel UPDATE statements on the same table create write-write conflicts under snapshot isolation in Microsoft Fabric. To fix this, avoid updating rows in parallel and use a set-based method like staging with MERGE or batch updates to minimize concurrent transactions. If necessary, run the ForEach activity sequentially (batch count = 1) and include retry logic to manage transient conflicts.
Transactions in Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn
Troubleshoot the Warehouse - Microsoft Fabric | Microsoft Learn
Thank you.
v-saisrao-msft
Community Support
4 months agoHI Abdul_Ismail,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.