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.