I am trying to pass a connection string from the secrets manager to mssqlhook like this
mssql+pyodbc://username:password@host\instance:port/schema
When I tried it without instance in a lower environment, it worked fine, but in our higher environment, we have an instance when I try to connect manually to SQL Server, it's working.
But when I am using in airflow code with help of mssqlhook I get an error due to the \ - I tried \\ and also // but that did not work either.
Error message:
Can anyone help me how to pass the connection string with instance?