apache-airflow-providers-odbc

Changelog¶

4.10.2¶

Release Date: 2025-08-02

Misc¶

Add Python 3.13 support for Airflow. (#46891)
Remove type ignore across codebase after mypy upgrade (#53243)
Remove upper-binding for "python-requires" (#52980)
Temporarily switch to use >=,< pattern instead of '~=' (#52967)

4.10.1¶

Release Date: 2025-07-06

Misc¶

Drop support for Python 3.9 (#52072)

4.10.0¶

Release Date: 2025-05-18

Note

This release of provider is only available for Airflow 2.10+ as explained in the Apache Airflow providers support policy <https://github.com/apache/airflow/blob/main/PROVIDERS.rst#minimum-supported-version-of-airflow-for-community-managed-providers>_.

Misc¶

Bump min Airflow version in providers to 2.10 (#49843)

4.9.2¶

Release Date: 2025-04-19

Misc¶

remove superfluous else block (#49199)

4.9.1¶

Release Date: 2025-03-13

Misc¶

Upgrade flit to 3.11.0 (#46938)

4.9.0¶

Release Date: 2024-12-26

Note

This release of provider is only available for Airflow 2.9+ as explained in the Apache Airflow providers support policy.

Misc¶

Bump minimum Airflow version in providers to Airflow 2.9.0 (#44956)

4.8.1¶

Release Date: 2024-11-18

Misc¶

Add support for semicolon stripping to DbApiHook, PrestoHook, and TrinoHook (#41916)

4.8.0¶

Release Date: 2024-10-31

Features¶

refactor: OdbcHook must use its own connection when creating a sqlalchemy engine (#43145)

4.7.1¶

Release Date: 2024-09-24

Misc¶

Generalize caching of connection in DbApiHook to improve performance (#40751)

4.7.0¶

Release Date: 2024-08-22

Note

This release of provider is only available for Airflow 2.8+ as explained in the Apache Airflow providers support policy.

Misc¶

Bump minimum Airflow version in providers to Airflow 2.8.0 (#41396)

4.6.3¶

Release Date: 2024-08-06

Misc¶

Clean up remaining getattr connection DbApiHook (#40665)

4.6.2¶

Release Date: 2024-06-27

Misc¶

implement per-provider tests with lowest-direct dependency resolution (#39946)

4.6.1¶

Release Date: 2024-05-30

Misc¶

Faster 'airflow_version' imports (#39552)
Simplify 'airflow_version' imports (#39497)

4.6.0¶

Release Date: 2024-05-06

Note

This release of provider is only available for Airflow 2.7+ as explained in the Apache Airflow providers support policy.

Bug Fixes¶

Always use the executemany method when inserting rows in DbApiHook as it's way much faster (#38715)

Misc¶

Bump minimum Airflow version in providers to Airflow 2.7.0 (#39240)

4.5.0¶

Release Date: 2024-04-13

Features¶

Make 'placeholder' of DbApiHook configurable in UI (#38528)

4.4.1¶

Release Date: 2024-01-27

Bug Fixes¶

Fix ODBC Hook sql select return empty table (#36709)
Rename columns to valid namedtuple attributes + ensure Row.fields are retrieved as tuple (#36949)

4.4.0¶

Release Date: 2023-12-27

Features¶

Make "placeholder" of ODBC configurable in UI (#36000)

Bug Fixes¶

Return common data structure in DBApi derived classes

4.3.0¶

Release Date: 2023-12-17

Note

This release of provider is only available for Airflow 2.6+ as explained in the Apache Airflow providers support policy.

Bug Fixes¶

Fix: Implement support for 'fetchone()' in the ODBCHook and the Databricks SQL Hook (#36161)

Misc¶

Bump minimum Airflow version in providers to Airflow 2.6.0 (#36017)

4.2.0¶

Release Date: 2023-11-29

Features¶

Make pyodbc.Row and databricks.Row JSON-serializable via new 'make_serializable' method (#32319)

4.1.0¶

Release Date: 2023-10-17

Note

This release of provider is only available for Airflow 2.5+ as explained in the Apache Airflow providers support policy.

Misc¶

Bump min airflow version of providers (#34728)

4.0.0¶

Release Date: 2023-06-23

Note

This release dropped support for Python 3.7

Breaking changes¶

The driver parameter has to be passed via keyword driver argument when initializing the Hook or via hook_params dictionary (with driver key) when instantiating Hook from SQL Operators. It was possible to instantiate it via extras before, but in this version, only setting it via constructor is supported.

Disable setting ODBC driver via extra by default (#31713)

Bug Fixes¶

Check if sqlalchemy_scheme extra contains forbidden characters (#31984)

Misc¶

Control permissibility of driver config in extra from airflow.cfg (#31754)

3.3.0¶

Release Date: 2023-05-22

Note

This release of provider is only available for Airflow 2.4+ as explained in the Apache Airflow providers support policy.

Misc¶

Bump minimum Airflow version in providers (#30917)

3.2.1¶

Release Date: 2022-11-29

Bug Fixes¶

Bump common.sql provider to 1.3.1 (#27888)

3.2.0¶

Release Date: 2022-11-18

Note

This release of provider is only available for Airflow 2.3+ as explained in the Apache Airflow providers support policy.

Misc¶

Move min airflow version to 2.3.0 for all providers (#27196)

3.1.2¶

Release Date: 2022-10-01

Misc¶

Add common-sql lower bound for common-sql (#25789)

3.1.1¶

Release Date: 2022-08-14

Bug Fixes¶

Fix odbc hook sqlalchemy_scheme docstring (#25421)

3.1.0¶

Release Date: 2022-07-16

Features¶

Move all SQL classes to common-sql provider (#24836)

3.0.0¶

Release Date: 2022-06-13

Breaking changes¶

Note

This release of provider is only available for Airflow 2.2+ as explained in the Apache Airflow providers support policy.

2.0.4¶

Release Date: 2022-03-26

Bug Fixes¶

Fix mistakenly added install_requires for all providers (#22382)

2.0.3¶

Release Date: 2022-03-19

Misc¶

Add Trove classifiers in PyPI (Framework :: Apache Airflow :: Provider)

2.0.2¶

Release Date: 2022-03-10

Misc¶

Support for Python 3.10

2.0.1¶

Release Date: 2021-09-03

Misc¶

Optimise connection importing for Airflow 2.2.0

2.0.0¶

Release Date: 2021-06-23

Breaking changes¶

Auto-apply apply_default decorator (#15667)

Warning

Due to apply_default decorator removal, this version of the provider requires Airflow 2.1.0+. If your Airflow version is < 2.1.0, and you want to install this provider version, first upgrade Airflow to at least version 2.1.0. Otherwise your Airflow package version will be upgraded automatically and you will have to manually run airflow upgrade db to complete the migration.

OdbcHook returns None. Related to #15016 issue. (#15510)

When you pass kwargs to the connection (for example autocommit and ansi) in connect_kwargs extra you should bass those as booleans. Previously strings were also supported.

"connect_kwargs": {
   "autocommit": "false",
   "ansi": "true"
}

should become

"connect_kwargs": {
   "autocommit": false,
   "ansi": true
}

Bug Fixes¶

Fix OdbcHook handling of port (#15772)

1.0.1¶

Release Date: 2021-02-08

Updated documentation and readme files.

1.0.0¶

Release Date: 2020-12-14

Initial version of the provider.