Making mssql provider to support only mssql+pymssql dialect

[rawwar]

Description

Currently, we allow users to pass dialect via sqlalchemy_scheme extra field of the mssql connections.

airflow/airflow/providers/microsoft/mssql/hooks/mssql.py

Line 80 in 3873b09

def sqlalchemy_scheme(self) -> str:

I am proposing to remove this field as it is not possible to support multiple dialects without installing the relevant dialect driver. Also, the documentation page does not even mention about sqlalchemy_scheme or the possibility of using other dialects.

Use case/motivation

Supporting multiple dialects requires the installation of multiple drivers. Since we only install pymssql, this allows the usage of the mssql+pymssql dialect alone and not others.

I am also interested in updating the documentation to reflect this.

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[rawwar]

@Taragolis , requesting your comments on this.

I was working on updating mssql provider to use sqlalchemy_url property in get_uri and got the idea for this issue.