Isolation levels
The SQL Server driver supports the following isolation levels for Microsoft SQL Server.
Note: For Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System, Read Uncommitted is the only supported isolation level.
Read Committed with Locks or Read Committed
Read Committed with Snapshots
Read Uncommitted
Repeatable Read
Serializable
Snapshot
For Microsoft SQL Server, the default is Read Committed with Locks or Read Committed.