MS SQL authentification with the managed identity

[keunsoopark]

I wanted to use SQL Mesh instead of dbt in MS SQL DB for saving costs, but it requires authentification with the managed identity instead of username & password.

I asked it out to Slack community, but got an answer that it is not supported - thread.

It would be great if SQL Mesh supports this like dbt - https://docs.getdbt.com/docs/core/connect-data-platform/mssql-setup#microsoft-entra-id-authentication

Not only managed identity but also entra id as well for local dev purpose.

[erindru]

This is essentially the same issue as #3481 and #3776

I don't think pymssql will ever reach feature parity with Microsoft's ODBC driver, particularly when Microsoft keeps adding weird and wonderful authentication types.

We should add support to SQLMesh but it's lower on the priority list at the moment, feel free to improve this PR or raise a PR

[georgesittas]

@erindru should we close this in favor of the other tickets? Or edit the others' descriptions to include this item?

[erindru]

The other tickets are already closed as not planned, so if anything this one should stay open to track the issue since it's come up a bunch of times and there is clearly demand for it

[georgesittas]

Ah I see, I thought one of them was open but didn't check. Thanks for clarifying 👍