Attribute error: 'MsSqlHook' object has no attribute 'get_conn_id' due to breaking changes made in a new release 3.8.0 of apache-airflow-providers-microsoft-mssql library

[Ishwin9]

Apache Airflow Provider(s)

microsoft-mssql

Versions of Apache Airflow Providers

apache-airflow-providers-microsoft-mssql - 3.8.0

Apache Airflow version

2.7.3

Operating System

linux

Deployment

Astronomer

Deployment details

No response

What happened

We are getting attribute error 'MsSqlHook' object has no attribute 'get_conn_id' due to breaking changes made in a new release 3.8.0 of apache-airflow-providers-microsoft-mssql library

What you think should happen instead

No response

How to reproduce

update apache-airflow-providers-microsoft-mssql library to 3.8.0

Anything else

No response

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

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

[boring-cyborg[bot]]

Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.

[Ishwin9]

[romsharon98]

It looks like it been solved with this PR: https://github.com/apache/airflow/pull/40615

[Ishwin9]

I am not sure if this is same. I had to downgrade the provider to 3.7.2 version and it was successful after that. This seems like a new bug after the new release of this provider