We have Metabase connecting to a production SQL Server. For various reasons we'd like to have it connect with transaction isolation level set to READ UNCOMMITTED (despite the risk of "dirty" reads). It connects with the isolation level set to READ COMMITTED. Is there any way to change this to default to READ UNCOMMITTED?
I have used a few other SQL clients where I could set the preferred isolation level when the connection was made and hope Metabase can do it too.
I did research the JDBC connections for additional options and looked at some magical .clj files in the GitHub source code but didn't find a way to make this happen.
Thanks in advance