apache-airflow-providers-odbc 4.0.0

Provider for Apache Airflow. Implements apache-airflow-providers-odbc package

Package apache-airflow-providers-odbc

Release: 4.0.0

ODBC

Provider package

This is a provider package for odbc provider. All classes for this provider package are in airflow.providers.odbc python package.

You can find package information and changelog for the provider in the documentation.

Installation

You can install this package on top of an existing Airflow 2 installation (see Requirements below for the minimum Airflow version supported) via pip install apache-airflow-providers-odbc

The package supports the following python versions: 3.8,3.9,3.10,3.11

Requirements

PIP package	Version required
apache-airflow	>=2.4.0
apache-airflow-providers-common-sql	>=1.3.1
pyodbc

Cross provider package dependencies

Those are dependencies that might be needed in order to use all the features of the package. You need to install the specified provider packages in order to use them.

You can install such cross-provider dependencies when installing from PyPI. For example:

pip install apache-airflow-providers-odbc[common.sql]

Dependent package	Extra
apache-airflow-providers-common-sql	common.sql

Changelog

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.