NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI · #615 most downloaded on PyPI
Provider package apache-airflow-providers-common-sql for Apache Airflow
Last release 2 days ago
29 Sep 2026
Ships fairly regularly
a new release about every 2 weeks
Nearly every release is documented
notes for 60 of the last 60 stable releases
4 versions withdrawn
withdrawn after publishing
4 years old
158 releases · first in 2022
Nothing published for this version
- Add requires_result_fetch Configuration to SQLExecuteQueryOperator
Release Date: 2025-04-09
Add requires_result_fetch Configuration to SQLExecuteQueryOperator (#46997)
Add requires_result_fetch Configuration to SQLExecuteQueryOperator (#46997)
One column per quarter.
Nothing published for this version
- Fix get_hook() got an unexpected keyword argument 'hook_params' in SQLExecuteQueryTrigger
Release Date: 2025-03-31
Fix get_hook() got an unexpected keyword argument 'hook_params' in SQLExecuteQueryTrigger (#47728)
Do not allow semicolon in partition_clause (#48098)
AIP-72: Handle Custom XCom Backend on Task SDK (#47339)
AIP-72: Implement short circuit and branch operators (#46584)
Fix get_hook() got an unexpected keyword argument 'hook_params' in SQLExecuteQueryTrigger (#47728)
Do not allow semicolon in partition_clause (#48098)
AIP-72: Handle Custom XCom Backend on Task SDK (#47339)
AIP-72: Implement short circuit and branch operators (#46584)
Nothing published for this version
Nothing published for this version
- fIx deprecation warnings in common.sql
Release Date: 2025-03-13
Add deferred pagination mode to GenericTransfer (#44809)
fIx deprecation warnings in common.sql (#47169)
Add missing 'methodtools' dependency of the 'common-sql' provider (#47148)
Upgrade flit to 3.11.0 (#46938)
Add deferred pagination mode to GenericTransfer (#44809)
fIx deprecation warnings in common.sql (#47169)
Add missing 'methodtools' dependency of the 'common-sql' provider (#47148)
Upgrade flit to 3.11.0 (#46938)
Nothing published for this version
This version contains no code changes. It was released to replace a previous version that was yanked due to a packaging issue.
Release Date: 2025-02-26
Note
This version contains no code changes. It was released to replace a previous version that was yanked due to a packaging issue.
Nothing published for this version
- Introduce notion of dialects in DbApiHook
Release Date: 2025-02-21
Introduce notion of dialects in DbApiHook (#41327)
Fix DbApiHook.insert_rows logging incorrect number of rows commited (#45789)
Fix escaping of special characters or reserved words as column names in dialects of common sql provider (#45640)
Add run_after column to DagRun model (#45732)
Adding type ignore to sql hook (#46163)
Added ADR document describing why the notion of dialects is introduced (#45456)
Bring back mypy checks for new-structure providers (#45815)
Remove obsolete pandas specfication for pre-python 3.9 (#45399)
Introduce notion of dialects in DbApiHook (#41327)
Fix DbApiHook.insert_rows logging incorrect number of rows commited (#45789)
Fix escaping of special characters or reserved words as column names in dialects of common sql provider (#45640)
Add run_after column to DagRun model (#45732)
Adding type ignore to sql hook (#46163)
Added ADR document describing why the notion of dialects is introduced (#45456)
Bring back mypy checks for new-structure providers (#45815)
Remove obsolete pandas specfication for pre-python 3.9 (#45399)
This has long been fixed and might affect users of very old provider versions. We are not considering this a breaking change yet we are listing the ch…
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 .
Warning
All deprecated classes, parameters and features have been removed from the Common SQL provider package. It could be that very old providers versions were depended on private functions of common.sql and as a result users may have created custom code around them without realizing using private functions. This has long been fixed and might affect users of very old provider versions. We are not considering this a breaking change yet we are listing the changes explicitly for visibility. The following breaking changes were introduced:
Remove _make_serializable method from DbApiHook . Use _make_common_data_structure instead.
Added output_processor parameter to SQLQueryOperator and fixed bug with return_single_query_results handler when None is passed as split_statements (#44781)
Moved common SQL handler methods of common-sql-provider into dedicated module (#43747)
Bump minimum Airflow version in providers to Airflow 2.9.0 (#44956)
Fix static checks in common SQL hooks (#44930)
Added documentation for the SqlThresholdCheckOperator (#44787)
Remove Provider Deprecations in Common SQL (#44645)
Update DAG example links in multiple providers documents (#44034)
Note
This release of provider is only available for Airflow 2.9+ as explained in the Apache Airflow providers support policy.
Warning
All deprecated classes, parameters and features have been removed from the Common SQL provider package. It could be that very old providers versions were depended on private functions of common.sql and as a result users may have created custom code around them without realizing using private functions. This has long been fixed and might affect users of very old provider versions. We are not considering this a breaking change yet we are listing the changes explicitly for visibility. The following breaking changes were introduced:
Remove _make_serializable method from DbApiHook. Use _make_common_data_structure instead.
Added output_processor parameter to SQLQueryOperator and fixed bug with return_single_query_results handler when None is passed as split_statements (#44781)
Moved common SQL handler methods of common-sql-provider into dedicated module (#43747)
Bump minimum Airflow version in providers to Airflow 2.9.0 (#44956)
Fix static checks in common SQL hooks (#44930)
Added documentation for the SqlThresholdCheckOperator (#44787)
Remove Provider Deprecations in Common SQL (#44645)
Update DAG example links in multiple providers documents (#44034)
Nothing published for this version
Nothing published for this version
- Add support for semicolon stripping to DbApiHook, PrestoHook, and TrinoHook
Release Date: 2024-11-18
Add support for semicolon stripping to DbApiHook, PrestoHook, and TrinoHook (#41916)
Add support for semicolon stripping to DbApiHook, PrestoHook, and TrinoHook (#41916)
Nothing published for this version
- Feature: Added fast_executemany parameter to insert_rows of DbApiHook
Release Date: 2024-10-31
Feature: Added fast_executemany parameter to insert_rows of DbApiHook (#43357)
Make conn id parameters templated in GenericTransfer and also allow passing hook parameters like in BaseSQLOperator (#42891)
Allow capture of replication lag in SqlSensor (#43107)
fix mypy failure (#43206)
Feature: Added fast_executemany parameter to insert_rows of DbApiHook (#43357)
Make conn id parameters templated in GenericTransfer and also allow passing hook parameters like in BaseSQLOperator (#42891)
Allow capture of replication lag in SqlSensor (#43107)
fix mypy failure (#43206)
Nothing published for this version
- feat(providers/common/sql): add warning to connection setter
Release Date: 2024-10-14
feat(providers/common/sql): add warning to connection setter (#42736)
FIX: Only pass connection to sqlalchemy engine in JdbcHook (#42705)
feat(providers/common/sql): add warning to connection setter (#42736)
FIX: Only pass connection to sqlalchemy engine in JdbcHook (#42705)
Nothing published for this version
- fix(providers/common/sql): add dummy connection setter for backward compatibility
Release Date: 2024-10-01
fix(providers/common/sql): add dummy connection setter for backward compatibility (#42490)
Changed type hinting for handler function (#42275)
Nothing published for this version
- remove deprecated soft_fail from providers
Release Date: 2024-09-24
Note
Connection in DB Hook is now cached to avoid multiple lookups when properties from extras have to be resolved.
Generalize caching of connection in DbApiHook to improve performance (#40751)
feat: log client db messages for provider postgres (#40171)
remove deprecated soft_fail from providers (#41710)
Nothing published for this version
This release of provider is only available for Airflow 2.8+ as explained in the Apache Airflow providers support policy .
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 .
fix: rm deprecated import (#41461)
Bump minimum Airflow version in providers to Airflow 2.8.0 (#41396)
Nothing published for this version
- Create SQLAlchemy engine from connection in DB Hook and added autocommit param to insert_rows method
Release Date: 2024-08-06
Create SQLAlchemy engine from connection in DB Hook and added autocommit param to insert_rows method (#40669)
Create SQLAlchemy engine from connection in DB Hook and added autocommit param to insert_rows method (#40669)
Nothing published for this version
- FIX: DbApiHook.insert_rows unnecessarily restarting connections
Release Date: 2024-07-12
FIX: DbApiHook.insert_rows unnecessarily restarting connections (#40615)
Enable enforcing pydocstyle rule D213 in ruff. (#40448)
FIX: DbApiHook.insert_rows unnecessarily restarting connections (#40615)
Enable enforcing pydocstyle rule D213 in ruff. (#40448)
Nothing published for this version
- implement per-provider tests with lowest-direct dependency resolution
Release Date: 2024-06-27
implement per-provider tests with lowest-direct dependency resolution (#39946)
Update pandas minimum requirement for Python 3.12 (#40272)
standardizes template fields for 'BaseSQLOperator' and adds 'database' as a templated field (#39826)
Nothing published for this version
- refactor: The executemany parameter of insert_rows should not be deprecated as for some hooks we don't want to enable a system-wide supports_execute…
Release Date: 2024-05-30
Add 'parameters' as template field for SqlSensor (#39588)
DbAPiHook: Don't log a warning message if placeholder is None and make sure warning message is formatted correctly (#39690)
refactor: The executemany parameter of insert_rows should not be deprecated as for some hooks we don't want to enable a system-wide supports_executemany parameter, that way we can also keep using it in dedicated situations (#39630)
Faster 'airflow_version' imports (#39552)
Simplify 'airflow_version' imports (#39497)
Add typing for SqlSensor (#39773)
Add 'parameters' as template field for SqlSensor (#39588)
DbAPiHook: Don't log a warning message if placeholder is None and make sure warning message is formatted correctly (#39690)
refactor: The executemany parameter of insert_rows should not be deprecated as for some hooks we don't want to enable a system-wide supports_executemany parameter, that way we can also keep using it in dedicated situations (#39630)
Faster 'airflow_version' imports (#39552)
Simplify 'airflow_version' imports (#39497)
Add typing for SqlSensor (#39773)
Nothing published for this version
This release of provider is only available for Airflow 2.7+ as explained in the Apache Airflow providers support policy .
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 .
Add 'sqlalchemy_url' property to 'DbApiHook' class (#38871)
Always use the executemany method when inserting rows in DbApiHook as it's way much faster (#38715)
Fix 'DbApiHook.insert_rows' when 'rows' is a generator (#38972)
Fix 'update-common-sql-api-stubs' pre-commit check (#38915)
Bump minimum Airflow version in providers to Airflow 2.7.0 (#39240)
openlineage, snowflake: do not run external queries for Snowflake (#39113)
Nothing published for this version
- Undeprecating 'DBApiHookForTests._make_common_data_structure'
Release Date: 2024-04-13
Add hook_params to template_fields for BaseSQLOperator-related Operators (#38724)
Make 'placeholder' of DbApiHook configurable in UI (#38528)
Undeprecating 'DBApiHookForTests._make_common_data_structure' (#38573)
Add hook_params to template_fields for BaseSQLOperator-related Operators (#38724)
Make 'placeholder' of DbApiHook configurable in UI (#38528)
Undeprecating 'DBApiHookForTests._make_common_data_structure' (#38573)
Nothing published for this version
- Make 'executemany' keyword arguments only in 'DbApiHook.insert_rows'
Release Date: 2024-03-08
Make 'executemany' keyword arguments only in 'DbApiHook.insert_rows' (#37840)
Limit 'pandas' to '<2.2' (#37748)
Nothing published for this version
- feat: Switch all class, functions, methods deprecations to decorators
Release Date: 2024-02-18
Enhancement: Performance enhancement for insert_rows method DbApiHook with fast executemany + SAP Hana support (#37246)
Fix SQLThresholdCheckOperator error on falsey vals (#37150)
feat: Switch all class, functions, methods deprecations to decorators (#36876)
Add more-itertools as dependency of common-sql (#37359)
Enhancement: Performance enhancement for insert_rows method DbApiHook with fast executemany + SAP Hana support (#37246)
Fix SQLThresholdCheckOperator error on falsey vals (#37150)
feat: Switch all class, functions, methods deprecations to decorators (#36876)
Add more-itertools as dependency of common-sql (#37359)
Nothing published for this version
Nothing published for this version
Nothing published for this version
- Set min pandas dependency to 1.2.5 for all providers and airflow
Release Date: 2024-01-27
Set min pandas dependency to 1.2.5 for all providers and airflow (#36698)
Set min pandas dependency to 1.2.5 for all providers and airflow (#36698)
Nothing published for this version
- Make "placeholder" of ODBC configurable in UI
Release Date: 2023-12-27
Make "placeholder" of ODBC configurable in UI (#36000)
Return common data structure in DBApi derived classes
SQLCheckOperator fails if returns dict with any False values (#36273)
Make "placeholder" of ODBC configurable in UI (#36000)
Return common data structure in DBApi derived classes
SQLCheckOperator fails if returns dict with any False values (#36273)
Nothing published for this version
This release of provider is only available for Airflow 2.6+ as explained in the Apache Airflow providers support policy .
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 .
Bump minimum Airflow version in providers to Airflow 2.6.0 (#36017)
Add Architecture Decision Record for common.sql introduction (#36015)
Nothing published for this version
- Add '_make_serializable' method which other SQL operators can overrides when result from cursor is not JSON-serializable
Release Date: 2023-11-29
Add '_make_serializable' method which other SQL operators can overrides when result from cursor is not JSON-serializable (#32319)
Remove backcompat inheritance for DbApiHook (#35754)
Add '_make_serializable' method which other SQL operators can overrides when result from cursor is not JSON-serializable (#32319)
Remove backcompat inheritance for DbApiHook (#35754)
Nothing published for this version
This release of provider is only available for Airflow 2.5+ as explained in the Apache Airflow providers support policy .
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 .
fix(providers/sql): respect soft_fail argument when exception is raised (#34199)
Bump min airflow version of providers (#34728)
Use 'airflow.exceptions.AirflowException' in providers (#34511)
Note
This release of provider is only available for Airflow 2.5+ as explained in the Apache Airflow providers support policy.
fix(providers/sql): respect soft_fail argument when exception is raised (#34199)
Bump min airflow version of providers (#34728)
Use 'airflow.exceptions.AirflowException' in providers (#34511)
Nothing published for this version
- Fix BigQueryValueCheckOperator deferrable mode optimisation
Release Date: 2023-09-12
Fix BigQueryValueCheckOperator deferrable mode optimisation (#34018)
Refactor regex in providers (#33898)
Nothing published for this version
- Refactor: Better percentage formatting
Release Date: 2023-08-29
Refactor: Better percentage formatting (#33595)
Refactor: Simplify code in smaller providers (#33234)
Refactor: Better percentage formatting (#33595)
Refactor: Simplify code in smaller providers (#33234)
Nothing published for this version
for the record, generated with: ~/node_modules/github-changes/bin/index.js -o airbnb -r airflow --only-pulls --use-commit-body --between-tags 1.6.2...
Raw changelog
for the record, generated with:
~/node_modules/github-changes/bin/index.js -o airbnb -r airflow --only-pulls --use-commit-body --between-tags 1.6.2...1.7.0rc1 --token {your_gh_token_here}
Session.remove after each run, to survive DB restart (@KMK-ONLINE)Release Date: 2023-08-14
Add a new parameter to SQL operators to specify conn id field (#30784)
Nothing published for this version
Your coding agent can read these notes before it upgrades. Set up the MCP server →