Dev-iL opened a new pull request, #76705: URL: https://github.com/apache/airflow/pull/76705
- related: #61229 The Snowflake provider's global `sqlalchemy<2.1` cap keeps constraints on SQLAlchemy 2.0 even though a compatible Snowflake dialect is now available. Require `snowflake-sqlalchemy>=2.1.0` and `snowflake-connector-python>=5.1.0` on Python 3.14+, and allow SQLAlchemy 2.1 there. The updated lock resolves SQLAlchemy 2.1.8 for those interpreters. Python 3.11–3.13 retain the cap: Snowpark requires connector `<5`, while the compatible dialect needs connector `>=5.1`. This preserves Snowpark and Airflow 2.11 support. Broader support remains tracked in #75118; this PR addresses the Python 3.14+ portion. Validation: - Python 3.14 Breeze, synchronized from the updated lock: Snowflake provider unit tests and common SQL operator tests — **962 passed, 10 skipped**. This includes Snowflake hook URI handling and OpenLineage event tests. Skips cover unavailable Snowpark and PostgreSQL/MySQL-only cases. - The four agent-framework checks listed by `breeze verify`, using the updated lock on Python 3.14: Strands **212 passed**, Google ADK **177 passed**, OpenAI Agents **263 passed**, LlamaIndex **207 passed**; other frameworks' tests skip in each isolated run. - Fast and manual static checks pass, including generated provider metadata, documentation tables, and lock consistency. - `breeze build-docs --answer no --package-filter apache-airflow-providers-snowflake` passes. --- ##### Was generative AI tooling used to co-author this PR? - [X] Yes — Codex (GPT-6) Generated-by: Codex (GPT-6) following [the guidelines](https://github.com/apache/airflow/blob/main/contributing-docs/05_pull_requests.rst#gen-ai-assisted-contributions) -- 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]
