I’m running a setup that uses sqlalchemy to work with Microsoft SQL. I couldn’t find any doc about it supporting odbc connections. Is microsoft odbc already configured in astronomer?
Astronomer doesn’t do anything specific regarding odbc. The way Airflow talks to the database is based on the operator/hook you are using. There is a mssql_hook provided by Airflow that uses the python pymssql library to connect to MS SQL Server. You would provide your connection details in an airflow connection. It looks like there are a few mssql operators that utilize this hook.