update conflict in Fabric data warehouse

[v-vepott]

Hi,

we are facing the Isolation update conflict on data warehouse table when I am updating the table multiple times in stored procedure and each time getting it in different update statements.

I have tried using BEGIN and END Transction with Delay time for each update statemnet but unfortunatly it is also not consistent some times getting successful and rest of the times with the same issue.

Is there any perment solution for it?.

Thanks in Advance

Venkat

[TwinkleCyril]

Hello, please review my recent blog post https://blog.fabric.microsoft.com/en-us/blog/concurrency-control-and-conflict-resolution-in-microsof... Hope this helps!