Locking and deadlocking for ms sql datasource

i have a Datasource that connects to an MS SQL instance. i’m noticing a lot of unexpected locking and even deadlocks when creating a new Suite using a simple custom SQL query for the data. Is there a way to prevent this from happening, maybe changing the isolation level associated with the connection?

I’m using SQLAlchemy, PYODBC and Microsoft ODBC Driver 17 for SQL Server (x64) for the connection.

Any direction is greatly appreciated.

  • Sean Fitz

Hi Sean - thanks for posting! Would you mind opening a GitHub issue? That will make it a little easier for the community to collaborate on this.

Just did, thank you for the direction.