Package apache-airflow-providers-common-sql

Common SQL Provider

This is detailed commit list of changes for versions provider package: common.sql. For high-level changelog, see package information including changelog.

1.21.0

Latest change: 2024-12-19

Commit

Committed

Subject

35b927fe17

2024-12-19

Update path of example dags in docs (#45069)

4b38bed76c

2024-12-16

Bump min version of Providers to 2.9 (#44956)

ad3d02205f

2024-12-14

Fix static checks in common SQL hooks (#44930)

bb259eaa67

2024-12-09

Added output_processor parameter to SQLQueryOperator and fixed bug with return_single_query_results handler when None is passed as split_statements (#44781)

f76883c95d

2024-12-09

Added documentation for the SqlThresholdCheckOperator (#44787)

2688d7ce6f

2024-12-05

Remove Provider Deprecations in Common SQL (#44645)

1275fec92f

2024-11-24

Use Python 3.9 as target version for Ruff & Black rules (#44298)

7a2fae0eef

2024-11-19

Moved common SQL handler methods of common-sql-provider into dedicated module (#43747)

4dfae23532

2024-11-15

Update DAG example links in multiple providers documents (#44034)

1.20.0

Latest change: 2024-11-14

Commit

Committed

Subject

a53d9f6d25

2024-11-14

Prepare docs for Nov 1st wave of providers (#44011)

e7194dff6a

2024-11-13

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

d8c7d28411

2024-10-30

Start porting DAG definition code to the Task SDK (#43076)

1.19.0

Latest change: 2024-10-27

Commit

Committed

Subject

78ff0a9970

2024-10-27

Prepare docs for Oct 2nd wave of providers (#43409)

a70038223e

2024-10-26

fix mypy failure (#43206)

2c394e3c85

2024-10-25

Feature: Added fast_executemany parameter to insert_rows of DbApiHook (#43357)

4d54cda411

2024-10-24

Make conn id parameters templated in GenericTransfer and also allow passing hook parameters like in BaseSQLOperator (#42891)

b86bb24984

2024-10-18

37437 (#43107)

857ca4c06c

2024-10-09

Split providers out of the main "airflow/" tree into a UV workspace project (#42505)

1.18.0

Latest change: 2024-10-09

Commit

Committed

Subject

2bb8628463

2024-10-09

Prepare docs for Oct 1st adhoc wave of providers (#42862)

9ba45b6d5f

2024-10-07

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

5973c9cce1

2024-10-04

feat(providers/common/sql): add warning to connection setter (#42736)

1.17.1

Latest change: 2024-09-27

Commit

Committed

Subject

bcee926d49

2024-09-27

Prepare docs for Sep 2nd adhoc wave of providers (#42519)

7ad586ed6a

2024-09-26

fix(providers/common/sql): add dummy connection setter for backward compatibility (#42490)

47c71108a8

2024-09-22

Changed type hinting for handler function (#42275)

1.17.0

Latest change: 2024-09-21

Commit

Committed

Subject

7628d47d04

2024-09-21

Prepare docs for Sep 1st wave of providers (#42387)

17c30b4f21

2024-09-05

feat: log client db messages for provider postgres (#40171)

2e813eb87d

2024-09-04

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

1613e9ec1c

2024-08-25

remove soft_fail (#41710)

1.16.0

Latest change: 2024-08-19

Commit

Committed

Subject

75fb7acbac

2024-08-19

Prepare docs for Aug 2nd wave of providers (#41559)

c8dc1971ad

2024-08-14

fix: rm deprecated import (#41461)

fcbff15bda

2024-08-12

Bump minimum Airflow version in providers to Airflow 2.8.0 (#41396)

1.15.0

Latest change: 2024-08-03

Commit

Committed

Subject

d23881c648

2024-08-03

Prepare docs for Aug 1st wave of providers (#41230)

f6c7388cfa

2024-07-26

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

1.14.2

Latest change: 2024-07-09

Commit

Committed

Subject

09a7bd1d58

2024-07-09

Prepare docs 1st wave July 2024 (#40644)

3f0979c9f1

2024-07-05

FIX: DbApiHook.insert_rows unnecessarily restarting connections (#40615)

a62bd83188

2024-06-27

Enable enforcing pydocstyle rule D213 in ruff. (#40448)

248e0a2eca

2024-06-23

Resolve postgres deprecations in tests (#40392)

1.14.1

Latest change: 2024-06-22

Commit

Committed

Subject

6e5ae26382

2024-06-22

Prepare docs 2nd wave June 2024 (#40273)

81c331e29a

2024-06-17

Update pandas minimum requirement for Python 3.12 (#40272)

c0f27094ab

2024-06-04

iMPlement per-provider tests with lowest-direct dependency resolution (#39946)

651a6d6a68

2024-06-03

standardizes template fields for 'BaseSQLOperator' and adds 'database' as a templated field (#39826)

1.14.0

Latest change: 2024-05-26

Commit

Committed

Subject

34500f3a2f

2024-05-26

Prepare docs 3rd wave May 2024 (#39738)

1734b15e4e

2024-05-23

Add typing for SqlSensor (#39773)

db80e5e21c

2024-05-18

DbAPiHook: Don't log a warning message if placeholder is None and make sure warning message is formatted correctly (#39690)

9669f51f0a

2024-05-15

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)

ce4e8477f1

2024-05-13

Add 'parameters' as template field for SqlSensor (#39588)

2b1a2f8d56

2024-05-11

Reapply templates for all providers (#39554)

2c05187b07

2024-05-10

Faster 'airflow_version' imports (#39552)

73918925ed

2024-05-08

Simplify 'airflow_version' imports (#39497)

1.13.0

Latest change: 2024-05-01

Commit

Committed

Subject

fe4605a10e

2024-05-01

Prepare docs 1st wave May 2024 (#39328)

ead9b00f7c

2024-04-25

Bump minimum Airflow version in providers to Airflow 2.7.0 (#39240)

ecc5af70eb

2024-04-22

openlineage, snowflake: do not run external queries for Snowflake (#39113)

08f4b923ab

2024-04-14

Add 'sqlalchemy_url' property to 'DbApiHook' class (#38871)

ed99893853

2024-04-12

Fix 'DbApiHook.insert_rows' when 'rows' is a generator (#38972)

7ab24c7723

2024-04-12

Always use the executemany method when inserting rows in DbApiHook as it's way much faster (#38715)

4f169bd2f3

2024-04-11

Fix 'update-common-sql-api-stubs' pre-commit check (#38915)

1.12.0

Latest change: 2024-04-10

Commit

Committed

Subject

5fa80b6aea

2024-04-10

Prepare docs 1st wave (RC1) April 2024 (#38863)

94153d70ac

2024-04-09

fix: try002 for provider common sql (#38800)

ef97ed245b

2024-04-07

Add hook_params to template_fields for BaseSQLOperator-related Operators (#38724)

0b1308ce45

2024-04-06

Make 'placeholder' of DbApiHook configurable in UI (#38528)

b06f401fa5

2024-03-28

Undeprecating 'DBApiHookForTests._make_common_data_structure' (#38573)

b5b972a106

2024-03-18

Update yanked versions in providers changelogs (#38262)

0a74928894

2024-03-18

Bump ruff to 0.3.3 (#38240)

1.11.1

Latest change: 2024-03-04

Commit

Committed

Subject

83316b8158

2024-03-04

Prepare docs 1st wave (RC1) March 2024 (#37876)

2ab60812a0

2024-03-01

Make 'executemany' keyword arguments only in 'DbApiHook.insert_rows' (#37840)

9e4bdc9e45

2024-02-27

Limit 'pandas' to '<2.2' (#37748)

1.11.0

Latest change: 2024-02-17

Commit

Committed

Subject

75182363a2

2024-02-17

Prepare docs 1st wave (RC2) of Providers February 2024 (#37471)

5a0be392e6

2024-02-16

Add comment about versions updated by release manager (#37488)

a457a75c05

2024-02-15

Added Supported Database Types (#37376)

b6ca84701e

2024-02-15

Fix SQLThresholdCheckOperator error on falsey vals (#37150)

560d073943

2024-02-12

Add more-itertools as dependency of common-sql (#37359)

bfb054e9e8

2024-02-12

Prepare docs 1st wave of Providers February 2024 (#37326)

70fd6ada39

2024-02-10

Enhancement: Performance enhancement for insert_rows method DbApiHook with fast executemany + SAP Hana support (#37246)

dec2662190

2024-01-30

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

1.10.1

Latest change: 2024-01-26

Commit

Committed

Subject

cead3da4a6

2024-01-26

Add docs for RC2 wave of providers for 2nd round of Jan 2024 (#37019)

0b680c9492

2024-01-26

Revert "Provide the logger_name param in providers hooks in order to override the logger name (#36675)" (#37015)

2b4da0101f

2024-01-22

Prepare docs 2nd wave of Providers January 2024 (#36945)

6bd450da1e

2024-01-10

Provide the logger_name param in providers hooks in order to override the logger name (#36675)

ecb2c9f24d

2024-01-09

Set min pandas dependency to 1.2.5 for all providers and airflow (#36698)

19ebcac239

2024-01-07

Prepare docs 1st wave of Providers January 2024 (#36640)

6937ae7647

2023-12-30

Speed up autocompletion of Breeze by simplifying provider state (#36499)

1.10.0

Latest change: 2023-12-23

Commit

Committed

Subject

b15d5578da

2023-12-23

Re-apply updated version numbers to 2nd wave of providers in December (#36380)

f5883d6e7b

2023-12-23

Prepare 2nd wave of providers in December (#36373)

5fe5d31a46

2023-12-22

Return common data structure in DBApi derived classes

f84eb2ab6f

2023-12-21

Make "placeholder" of ODBC configurable in UI (#36000)

5c1d8f40a1

2023-12-20

SQLCheckOperator fails if returns dict with any False values (#36273)

1.9.0

Latest change: 2023-12-08

Commit

Committed

Subject

999b70178a

2023-12-08

Prepare docs 1st wave of Providers December 2023 (#36112)

d0918d77ee

2023-12-07

Bump minimum Airflow version in providers to Airflow 2.6.0 (#36017)

3bb5978e63

2023-12-06

Add Architecture Decision Record for common.sql introduction (#36015)

1.8.1

Latest change: 2023-11-24

Commit

Committed

Subject

0b23d5601c

2023-11-24

Prepare docs 2nd wave of Providers November 2023 (#35836)

2a469b3713

2023-11-21

Remove backcompat inheritance for DbApiHook (#35754)

99534e47f3

2023-11-19

Use reproducible builds for provider packages (#35693)

064fc2b775

2023-11-17

Make pyodbc.Row and databricks.Row JSON-serializable via new 'make_serializable' method (#32319)

99df205f42

2023-11-16

Fix and reapply templates for provider documentation (#35686)

1b059c57d6

2023-11-08

Prepare docs 1st wave of Providers November 2023 (#35537)

11bdfe4c12

2023-11-07

Work around typing issue in examples and providers (#35494)

706878ec35

2023-11-04

Remove empty lines in generated changelog (#35436)

052e26ad47

2023-11-04

Change security.rst to use includes in providers (#35435)

d1c58d86de

2023-10-28

Prepare docs 3rd wave of Providers October 2023 - FIX (#35233)

3592ff4046

2023-10-28

Prepare docs 3rd wave of Providers October 2023 (#35187)

dd7ba3cae1

2023-10-19

Pre-upgrade 'ruff==0.0.292' changes in providers (#35053)

b75f9e8806

2023-10-18

Upgrade pre-commits (#35033)

f23170c9dd

2023-10-16

D401 Support - A thru Common (Inclusive) (#34934)

1.8.0

Latest change: 2023-10-13

Commit

Committed

Subject

e9987d5059

2023-10-13

Prepare docs 1st wave of Providers in October 2023 (#34916)

128f6b9e40

2023-10-13

Add missing header into 'common.sql' changelog (#34910)

0c8e30e43b

2023-10-05

Bump min airflow version of providers (#34728)

7ebf4220c9

2023-09-28

Refactor usage of str() in providers (#34320)

659d94f0ae

2023-09-21

Use 'airflow.exceptions.AirflowException' in providers (#34511)

f5c2748c33

2023-09-08

fix(providers/sql): respect soft_fail argument when exception is raised (#34199)

1.7.2

Latest change: 2023-09-08

Commit

Committed

Subject

21990ed894

2023-09-08

Prepare docs for 09 2023 - 1st wave of Providers (#34201)

a7310f9c91

2023-09-05

Refactor regex in providers (#33898)

d757f6a3af

2023-09-03

Fix BigQueryValueCheckOperator deferrable mode optimisation (#34018)

1.7.1

Latest change: 2023-08-26

Commit

Committed

Subject

c077d19060

2023-08-26

Prepare docs for Aug 2023 3rd wave of Providers (#33730)

92474db6a5

2023-08-23

Refactor: Better percentage formatting (#33595)

a54c2424df

2023-08-23

Fix typos (double words and it's/its) (#33623)

a91ee7ac2f

2023-08-20

Refactor: Simplify code in smaller providers (#33234)

1.7.0

Latest change: 2023-08-11

Commit

Committed

Subject

b5a4d36383

2023-08-11

Prepare docs for Aug 2023 2nd wave of Providers (#33291)

9736143468

2023-08-07

Add a new parameter to SQL operators to specify conn id field (#30784)

1.6.2

Latest change: 2023-08-05

Commit

Committed

Subject

60677b0ba3

2023-08-05

Prepare docs for Aug 2023 1st wave of Providers (#33128)

cfac7d379f

2023-08-04

Make SQLExecute Query signature consistent with other SQL operators (#32974)

e3d82c6be0

2023-08-04

Get rid of Python2 numeric relics (#33050)

1.6.1

Latest change: 2023-07-29

Commit

Committed

Subject

d06b7af69a

2023-07-29

Prepare docs for July 2023 3rd wave of Providers (#32875)

ce2841bf6a

2023-07-25

Add default port to Openlineage authority method. (#32828)

73b90c48b1

2023-07-21

Allow configuration to be contributed by providers (#32604)

60c49ab2df

2023-07-19

Add more accurate typing for DbApiHook.run method (#31846)

ef0ed1aacc

2023-07-06

Fix local OpenLineage import in 'SQLExecuteQueryOperator'. (#32400)

1.6.0

Latest change: 2023-07-06

Commit

Committed

Subject

225e3041d2

2023-07-06

Prepare docs for July 2023 wave of Providers (RC2) (#32381)

3878fe6fab

2023-07-05

Remove spurious headers for provider changelogs (#32373)

ee4a838d49

2023-07-05

Pass SQLAlchemy engine to construct information schema query. (#32371)

cb4927a018

2023-07-05

Prepare docs for July 2023 wave of Providers (#32298)

f2e2125b07

2023-06-29

openlineage, common.sql:  provide OL SQL parser as internal OpenLineage provider API (#31398)

8c37b74a20

2023-06-28

D205 Support - Providers: Apache to Common (inclusive) (#32226)

09d4718d3a

2023-06-27

Improve provider documentation and README structure (#32125)

1.5.2

Latest change: 2023-06-20

Commit

Committed

Subject

79bcc2e668

2023-06-20

Prepare RC1 docs for June 2023 wave of Providers (#32001)

9276310a43

2023-06-05

Improve docstrings in providers (#31681)

a59076eaee

2023-06-02

Add D400 pydocstyle check - Providers (#31427)

9fa75aaf7a

2023-05-29

Remove Python 3.7 support (#30963)

1.5.1

Latest change: 2023-05-24

Commit

Committed

Subject

d745cee3db

2023-05-24

Prepare adhoc wave of Providers (#31478)

547e352578

2023-05-23

Bring back min-airflow-version for preinstalled providers (#31469)

1.5.0

Latest change: 2023-05-19

Commit

Committed

Subject

45548b9451

2023-05-19

Prepare RC2 docs for May 2023 wave of Providers (#31416)

abea189022

2023-05-18

Use '__version__' in providers not 'version' (#31393)

f5aed58d9f

2023-05-18

Fixing circular import error in providers caused by airflow version check (#31379)

d9ff55cf6d

2023-05-16

Prepare docs for May 2023 wave of Providers (#31252)

edd7133a13

2023-05-09

Add conditional output processing in SQL operators (#31136)

00a527f671

2023-05-08

Remove noisy log from SQL table check (#31037)

eef5bc7f16

2023-05-03

Add full automation for min Airflow version for providers (#30994)

d23a3bbed8

2023-04-04

Add mechanism to suspend providers (#30422)

1.4.0

Latest change: 2023-04-02

Commit

Committed

Subject

55dbf1ff1f

2023-04-02

Prepare docs for April 2023 wave of Providers (#30378)

a9b79a27b2

2023-03-08

Add option to show output of 'SQLExecuteQueryOperator' in the log (#29954)

95710e0cdd

2023-03-03

Fix Python API docs formatting for Common SQL provider (#29863)

1.3.4

Latest change: 2023-03-03

Commit

Committed

Subject

fcd3c0149f

2023-03-03

Prepare docs for 03/2023 wave of Providers (#29878)

19f1e7c27b

2023-02-22

Do not process output when do_xcom_push=False  (#29599)

ce6ae2457e

2023-02-08

Prepare docs for Feb 2023 wave of Providers (#29379)

0af6f20c5f

2023-01-30

Make the S3-to-SQL system test self-contained (#29204)

129f0820cd

2023-01-23

Make static checks generated file  more stable accross the board (#29080)

1.3.3

Latest change: 2023-01-14

Commit

Committed

Subject

911b708ffd

2023-01-14

Prepare docs for Jan 2023 mid-month wave of Providers (#28929)

9a7f07491e

2023-01-09

Handle non-compliant behaviour of Exasol cursor (#28744)

1.3.2

Latest change: 2023-01-02

Commit

Committed

Subject

5246c009c5

2023-01-02

Prepare docs for Jan 2023 wave of Providers (#28651)

2e7b9f5504

2022-12-29

Defer to hook setting for split_statements in SQLExecuteQueryOperator (#28635)

f115b207bc

2022-12-18

fIx isort problems introduced by recent isort release (#28434)

a6cda7cd23

2022-12-10

Fix template rendering for Common SQL operators (#28202)

6852f3fbea

2022-12-05

Add pre-commits preventing accidental API changes in common.sql (#27962)

c8e348dcb0

2022-12-05

Add automated version replacement in example dag indexes (#28090)

a158fbb6bd

2022-11-28

Clarify docstrings for updated DbApiHook (#27966)

1.3.1

Latest change: 2022-11-26

Commit

Committed

Subject

25bdbc8e67

2022-11-26

Updated docs for RC3 wave of providers (#27937)

db5375bea7

2022-11-26

Fixing the behaviours of SQL Hooks and Operators finally (#27912)

2e20e9f7eb

2022-11-24

Prepare for follow-up relase for November providers (#27774)

80c327bd3b

2022-11-24

Bump common.sql provider to 1.3.1 (#27888)

ea306c9462

2022-11-24

Fix errors in Databricks SQL operator introduced when refactoring (#27854)

dbb4b59dcb

2022-11-23

Restore removed (but used) methods in common.sql (#27843)

1.3.0

Latest change: 2022-11-15

Commit

Committed

Subject

12c3c39d1a

2022-11-15

pRepare docs for November 2022 wave of Providers (#27613)

3ae98b824d

2022-11-14

Use unused SQLCheckOperator.parameters in SQLCheckOperator.execute. (#27599)

5c37b503f1

2022-10-31

Use DbApiHook.run for DbApiHook.get_records and DbApiHook.get_first (#26944)

9ab1a6a3e7

2022-10-27

Update old style typing (#26872)

87eb46bbc6

2022-10-26

Common sql bugfixes and improvements (#26761)

78b8ea2f22

2022-10-24

Move min airflow version to 2.3.0 for all providers (#27196)

2a34dc9e84

2022-10-23

Enable string normalization in python formatting - providers (#27205)

ecd4d6654f

2022-10-18

Add SQLExecuteQueryOperator (#25717)

76014609c0

2022-10-09

DbApiHook consistent insert_rows logging (#26758)

674f9ce6ea

2022-10-01

A few docs fixups (#26788)

f8db64c35c

2022-09-28

Update docs for September Provider's release (#26731)

06acf40a43

2022-09-13

Apply PEP-563 (Postponed Evaluation of Annotations) to non-core airflow (#26289)

1.2.0

Latest change: 2022-09-05

Commit

Committed

Subject

25d0baa4ee

2022-09-05

Prepare bug-fix release of providers out of band (#26109)

27e2101f6e

2022-08-30

Better error messsage for pre-common-sql providers (#26051)

a74d934991

2022-08-27

Fix placeholders in 'TrinoHook', 'PrestoHook', 'SqliteHook' (#25939)

874a95cc17

2022-08-22

Discard semicolon stripping in SQL hook (#25855)

dd72e67524

2022-08-19

Fix (and test) SQLTableCheckOperator on postgresql (#25821)

5b3d579a42

2022-08-19

Don't use Pandas for SQLTableCheckOperator (#25822)

1.1.0

Latest change: 2022-08-15

Commit

Committed

Subject

7d0525a55b

2022-08-15

Prepare documentation for RC4 release of providers (#25720)

7a19651369

2022-08-15

Fix SQL split string to include ';-less' statements (#25713)

5923788143

2022-08-10

Fix CHANGELOG for common.sql provider and add amazon commit (#25636)

e5ac6c7cfb

2022-08-10

Prepare docs for new providers release (August 2022) (#25618)

d82436b382

2022-08-05

Fix fetch_all_handler & db-api tests for it (#25430)

348a28957a

2022-08-04

Align Common SQL provider logo location (#25538)

acab8f52dd

2022-07-29

Move all "old" SQL operators to common.sql providers (#25350)

b0fd105f4a

2022-07-28

Allow Legacy SqlSensor to use the common.sql providers (#25293)

5d4abbd58c

2022-07-27

Deprecate hql parameters and synchronize DBApiHook method APIs (#25299)

df00436569

2022-07-22

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

be7cb1e837

2022-07-22

Common SQLCheckOperators Various Functionality Update (#25164)

1.0.0

Latest change: 2022-07-13

Commit

Committed

Subject

d2459a241b

2022-07-13

Add documentation for July 2022 Provider's release (#25030)

46bbfdade0

2022-07-07

Move all SQL classes to common-sql provider (#24836)

Was this entry helpful?