apache-airflow-providers-jdbc

Changelog¶

5.0.0¶

Note

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

Breaking changes¶

Warning

All deprecated classes, parameters and features have been removed from the JDBC provider package. The following breaking changes were introduced:

Operators
- Remove airflow.providers.jdbc.operators.jdbc.JdbcOperator. Please use airflow.providers.common.sql.operators.sql.SQLExecuteQueryOperator instead.

Remove Provider Deprecations in JDBC (#44662)

Bug Fixes¶

Made get_conn in JdbcHook threadsafe to avoid OSError: JVM is already started (#44718)
Suppress JException when get_autocommit and set_autocommit methods aren't supported on JDBC driver (#43786)

Misc¶

Bump minimum Airflow version in providers to Airflow 2.9.0 (#44956)
Update DAG example links in multiple providers documents (#44034)

4.5.3¶

Misc¶

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

4.5.2¶

Bug Fixes¶

FIX: Only pass connection to sqlalchemy engine in JdbcHook (#42705)

4.5.1¶

Misc¶

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

4.5.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.4.0¶

Features¶

Create SQLAlchemy engine from connection in DB Hook and added autocommit param to insert_rows method (#40669)

Misc¶

Clean up remaining getattr connection DbApiHook (#40665)

4.3.1¶

Misc¶

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

4.3.0¶

Note

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

Bug Fixes¶

Suppress jaydebeapi.Error when setAutoCommit or getAutoCommit is unsupported by JDBC driver (#38707)

Misc¶

Bump minimum Airflow version in providers to Airflow 2.7.0 (#39240)
Add stacklevel into the 'suppress_and_warn' warning (#39263)

4.2.2¶

Misc¶

feat: Switch all class, functions, methods deprecations to decorators (#36876)

4.2.1¶

Bug Fixes¶

Follow BaseHook connection fields method signature in child classes (#36086)

4.2.0¶

Note

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

Misc¶

Bump minimum Airflow version in providers to Airflow 2.6.0 (#36017)
Add configuration ref to "providers.jdbc" (#35580)

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.2¶

Misc¶

Improve modules import in Airflow providers by some of them into a type-checking block (#33754)

4.0.1¶

Misc¶

Add deprecation info to the providers modules and classes docstring (#32536)

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:

Supply them as constructor arguments when instantiating the hook.
Set the driver_path and/or driver_class parameters in the hook_params dictionary when creating the hook using SQL operators.
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.
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.