Invalid uri created when extras contains non string elements - imact for alchemy connection

[core3-marcin-molak]

Apache Airflow version

3.0.6

If "Other Airflow 2 version" selected, which one?

No response

What happened?

I have create extra for sql server connection with the following extras:

{ "tds_version":"7.3", "as_dict":true }

I got uri with
extra=%7B%22tds_version%22%3A+%227.3%22%2C+%22as_dict%22%3A+1%7D

and alchemy have issue with extra parameter.

When I change boolean into string:
{ "tds_version":"7.3", "as_dict":"true" }

uri contains: ?tds_version=7.3&as_dict=true

but alchemy have problem with map from string into boolean

What you think should happen instead?

No response

How to reproduce

Add extras to connection and try to get alchemy_connection for sql server

Operating System

Ubuntu

Versions of Apache Airflow Providers

No response

Deployment

Virtualenv installation

Deployment details

No response

Anything else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

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

[boring-cyborg]

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.

[core3-marcin-molak]

Additional comment - uri is created in invalid way in Connection class (not in MSSqlServer provider)

[eladkal]

cc @Pyasma maybe you'd be interested in checking this issue?

[Pyasma]

Thanks for letting me know. I’ll look into it.