Taragolis commented on issue #28723:
URL: https://github.com/apache/airflow/issues/28723#issuecomment-1855694165
Just for the record, fix all stuff do not automatically granted ability to
run Airflow with SQLAlchemy 2.0, due to upper bound limitation of Airflow and
Providers dependencies:
```console
root@4c41f46e319c:/opt/airflow# pipdeptree --packages sqlalchemy -r
SQLAlchemy==1.4.50
├── alembic==1.13.0 [requires: SQLAlchemy>=1.3.0]
│ ├── apache-airflow==2.9.0.dev0 [requires: alembic>=1.6.3,<2.0]
│ ├── databricks-sql-connector==2.9.3 [requires: alembic>=1.0.11,<2.0.0]
│ └── sqlalchemy-spanner==1.6.2 [requires: alembic]
├── apache-airflow==2.9.0.dev0 [requires: SQLAlchemy>=1.4.28,<2.0]
├── databricks-sql-connector==2.9.3 [requires: SQLAlchemy>=1.3.24,<2.0.0]
├── eralchemy2==1.3.8 [requires: SQLAlchemy>=1.4]
├── Flask-AppBuilder==4.3.10 [requires: SQLAlchemy<1.5]
│ └── apache-airflow==2.9.0.dev0 [requires: Flask-AppBuilder==4.3.10]
├── Flask-SQLAlchemy==2.5.1 [requires: SQLAlchemy>=0.8.0]
│ └── Flask-AppBuilder==4.3.10 [requires: Flask-SQLAlchemy>=2.4,<3]
│ └── apache-airflow==2.9.0.dev0 [requires: Flask-AppBuilder==4.3.10]
├── marshmallow-sqlalchemy==0.26.1 [requires: SQLAlchemy>=1.2.0]
│ └── Flask-AppBuilder==4.3.10 [requires:
marshmallow-sqlalchemy>=0.22.0,<0.27.0]
│ └── apache-airflow==2.9.0.dev0 [requires: Flask-AppBuilder==4.3.10]
├── snowflake-sqlalchemy==1.5.1 [requires: SQLAlchemy>=1.4.0,<2.0.0]
├── sqlalchemy-bigquery==1.9.0 [requires: SQLAlchemy>=1.2.0,<2.0.0dev]
├── sqlalchemy-drill==1.1.4 [requires: SQLAlchemy]
├── SQLAlchemy-JSONField==1.0.2 [requires: SQLAlchemy]
│ └── apache-airflow==2.9.0.dev0 [requires: SQLAlchemy-JSONField>=1.0]
├── sqlalchemy-redshift==0.8.14 [requires: SQLAlchemy>=0.9.2,<2.0.0]
├── sqlalchemy-spanner==1.6.2 [requires: SQLAlchemy>=1.1.13]
└── SQLAlchemy-Utils==0.41.1 [requires: SQLAlchemy>=1.3]
└── Flask-AppBuilder==4.3.10 [requires: SQLAlchemy-Utils>=0.32.21,<1]
└── apache-airflow==2.9.0.dev0 [requires: Flask-AppBuilder==4.3.10]
```
Also required that this packages also supports SA 2.0:
- [Flask-AppBuilder](https://pypi.org/project/Flask-AppBuilder/) - Doesn't
support SA 2.0 yet
-
[databricks-sql-connector](https://pypi.org/project/databricks-sql-connector/)
- Support SA 2.0 from 3.0.0, and drop support 1.4
- [snowflake-sqlalchemy](https://pypi.org/project/snowflake-sqlalchemy/) -
Doesn't support SA 2.0 yet
- [sqlalchemy-bigquery](https://pypi.org/project/sqlalchemy-bigquery/) -
Doesn't support SA 2.0 yet
- [sqlalchemy-redshift](https://pypi.org/project/sqlalchemy-redshift/) -
Doesn't support SA 2.0 yet
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
