A complete solution for open data platforms, enterprise data catalogs, data lakes and data management. Open source, mature, fully-featured and production ready.

DataHub

For the MSSQL source are we able to set the isolation level?

<https://python-tds.readthedocs.io/en/latest/pytds.html#pytds.Connection.isolation_level>

We are experiencing blocking on a few of our tables due to profiling being enabled.

<@U0206BTERQE>,  I think you can specify the isolation level for MSSQL using the `options` config field <https://datahubproject.io/docs/metadata-ingestion/source_docs/mssql|MSSQL Datahub Source Configuration>. Also see <https://docs.sqlalchemy.org/en/14/core/engines.html#sqlalchemy.create_engine|SQL Alchemy Engine>.

thanks for the info <@U028L1V9BE1> I was already headed down that path.

```table_pattern:
      deny:
        - "^.*\\.sys_.*" # deny all tables that start with sys_
        - "^.*\\.cdc.*"
    options:
      isolation_level: "READ UNCOMMITTED"
    profiling:
      enabled: true```

had to comment out line 143 in site-packages/sqlalchemy_pytds/dialect.py