Forum Discussion
concurrency lock condition error when writing multiple records to an audit log table simultaneously.
Issue: Facing lock condition errors when writing multiple records to an audit log table simultaneously. Setup: One master pipeline invoking multiple child pipelines. Audit log notebook placed in ...
Hi Anonymous are you using the Warehouse service? It uses snapshot isolation and has only table level locking. Concurrent UPDATE statements will likely cause issues. I explain further here:
https://www.serverlesssql.com/transaction-isolation-in-fabric-warehouses/