apache-airflow-providers-odbc

Changelog¶

4.8.1¶

Misc¶

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

4.8.0¶

Features¶

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

4.7.1¶

Misc¶

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

4.7.0¶

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¶

Misc¶

Clean up remaining getattr connection DbApiHook (#40665)

4.6.2¶

Misc¶

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

4.6.1¶

Misc¶

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

4.6.0¶

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¶

Features¶

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

4.4.1¶

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¶

Features¶

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

Bug Fixes¶

Return common data structure in DBApi derived classes

4.3.0¶

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¶

Features¶

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

4.1.0¶

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¶

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¶

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¶

Bug Fixes¶

Bump common.sql provider to 1.3.1 (#27888)

3.2.0¶

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¶

Misc¶

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

3.1.1¶

Bug Fixes¶

Fix odbc hook sqlalchemy_scheme docstring (#25421)

3.1.0¶

Features¶

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

3.0.0¶

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¶

Bug Fixes¶

Fix mistakenly added install_requires for all providers (#22382)

2.0.3¶

Misc¶

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

2.0.2¶

Misc¶

Support for Python 3.10

2.0.1¶

Misc¶

Optimise connection importing for Airflow 2.2.0

2.0.0¶

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¶

Updated documentation and readme files.

1.0.0¶

Initial version of the provider.