apache-airflow-providers-jdbc 4.0.0

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

Package apache-airflow-providers-jdbc

Release: 4.0.0

Java Database Connectivity (JDBC)

Provider package

This is a provider package for jdbc provider. All classes for this provider package are in airflow.providers.jdbc 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-jdbc

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
jaydebeapi	>=1.1.1

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-jdbc[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

To configure driver parameters (driver path and driver class), you can use the following methods:

1. Supply them as constructor arguments when instantiating the hook.

2. Set the “driver_path” and/or “driver_class” parameters in the “hook_params” dictionary when creating the hook using SQL operators.

3. Set the “driver_path” and/or “driver_class” extra in the connection and correspondingly enable the “allow_driver_path_in_extra” and/or “allow_driver_class_in_extra” options in the “providers.jdbc” section of the Airflow configuration.

4. Patch the “JdbcHook.default_driver_path” and/or “JdbcHook.default_driver_class” values in the “local_settings.py” file.

• Restrict direct usage of driver params via extras for JDBC connection (#31849)

3.4.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.3.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)

Features

In JdbcHook, non-prefixed extra fields are supported and are preferred. E.g. drv_path will be preferred if extra__jdbc__drv_path is also present.

• Allow and prefer non-prefixed extra fields for JdbcHook (#27044)

• Add SQLExecuteQueryOperator (#25717)

Bug Fixes

• Bump common.sql provider to 1.3.1 (#27888)

3.2.1

Misc

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

3.2.0

Features

• Adding configurable fetch_all_handler for JdbcOperator (#25412)

• Unify DbApiHook.run() method with the methods which override it (#23971)

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.

Features

• Handler parameter from 'JdbcOperator' to 'JdbcHook.run' (#23817)

2.1.3

Bug Fixes

• Fix mistakenly added install_requires for all providers (#22382)

2.1.2

Misc

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

2.1.1

Misc

• Support for Python 3.10

2.1.0

Features

• Add more SQL template fields renderers (#21237)

• Add optional features in providers. (#21074)

2.0.1

Bug Fixes

• Fix type annotations in OracleOperator, JdbcOperator, SqliteOperator (#17406)

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.

1.0.1

Updated documentation and readme files.

1.0.0

Initial version of the provider.