Taragolis commented on issue #35468: URL: https://github.com/apache/airflow/issues/35468#issuecomment-1794266093
There is quite a few different problem with installation and extending Airflow image in the one place - Official Airflow image for 2.7.2 based on Debian Bullseye but you tried to install Ubuntu package. BTW, regular Airflow image already include ODBC Driver for Microsoft(R) SQL Server(R) - Seems like you install python packages into the root userspace, however in the official image Airflow doesn't use root user. You could follow [Building the image](https://airflow.apache.org/docs/docker-stack/build.html#building-the-image) guide. > When adding packages via apt you should switch to the `root` user when running the apt commands, but do not forget to switch back to the `airflow` user after installation is complete. - `sqlalchemy==2.0.23` - Airflow doesn't support SQLAlchemy 2 yet. The issue for tracking status: https://github.com/apache/airflow/issues/28723. But please note that this only related to the Airflow itself, other depenedncies might still required sqlalchemy<2 - Last but not least. Support of Microsoft SQL Server as DB backend for Airflow [will be discontinued soon](https://airflow.apache.org/docs/apache-airflow/2.7.2/howto/set-up-database.html#setting-up-a-mssql-database). It is not clear what kind of DB backend are you use but my assumption that is MsSQL -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@airflow.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
