apache-airflow-providers-jdbc

Changelog¶

5.2.3¶

Release Date: 2025-09-09

Bug Fixes¶

Fixed resolving of dialect name when host of JdbcHook is an JDBC URL (#54446)

Doc-only¶

Make term Dag consistent in providers docs (#55101)

5.2.2¶

Release Date: 2025-08-02

Misc¶

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

5.2.1¶

Release Date: 2025-07-06

Misc¶

Move 'BaseHook' implementation to task SDK (#51873)
Drop support for Python 3.9 (#52072)

5.2.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)

5.1.0¶

Release Date: 2025-04-19

Features¶

feat: overwrite 'get_uri' for 'JDBC' (#48915)

5.0.1¶

Release Date: 2025-03-13

Misc¶

Upgrade flit to 3.11.0 (#46938)

5.0.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.

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¶

Release Date: 2024-11-18

Misc¶

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

4.5.2¶

Release Date: 2024-10-14

Bug Fixes¶

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

4.5.1¶

Release Date: 2024-09-24

Misc¶

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

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

Release Date: 2024-08-06

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¶

Release Date: 2024-05-30

Misc¶

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

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

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¶

Release Date: 2024-02-15

Misc¶

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

4.2.1¶

Release Date: 2023-12-27

Bug Fixes¶

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

4.2.0¶

Release Date: 2023-12-12

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¶

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

Release Date: 2023-09-12

Misc¶

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

4.0.1¶

Release Date: 2023-08-01

Misc¶

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

4.0.0¶

Release Date: 2023-06-23

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¶

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

Release Date: 2022-11-29

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¶

Release Date: 2022-10-01

Misc¶

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

3.2.0¶

Release Date: 2022-08-14

Features¶

Adding configurable fetch_all_handler for JdbcOperator (#25412)
Unify DbApiHook.run() method with the methods which override it (#23971)

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.

Features¶

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

2.1.3¶

Release Date: 2022-03-26

Bug Fixes¶

Fix mistakenly added install_requires for all providers (#22382)

2.1.2¶

Release Date: 2022-03-19

Misc¶

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

2.1.1¶

Release Date: 2022-03-10

Misc¶

Support for Python 3.10

2.1.0¶

Release Date: 2022-02-13

Features¶

Add more SQL template fields renderers (#21237)
Add optional features in providers. (#21074)

2.0.1¶

Release Date: 2021-09-03

Bug Fixes¶

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

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.

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.