apache-airflow-providers-postgres
Changelog¶
5.13.0¶
Features¶
feat: log client db messages for provider postgres (#40171)
Misc¶
Generalize caching of connection in DbApiHook to improve performance (#40751)
5.12.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)
5.11.1¶
Bug Fixes¶
fix: use 'sqlalchemy_url' property in 'get_uri' for postgresql provider (#38831)
Misc¶
Faster 'airflow_version' imports (#39552)
Simplify 'airflow_version' imports (#39497)
5.11.0¶
Note
This release of provider is only available for Airflow 2.7+ as explained in the Apache Airflow providers support policy.
Bug Fixes¶
Fix schema assigment in PostgresOperator (#39264)
Misc¶
Bump minimum Airflow version in providers to Airflow 2.7.0 (#39240)
Always use the executemany method when inserting rows in DbApiHook as it's way much faster (#38715)
5.10.0¶
Features¶
Make "placeholder" of ODBC configurable in UI (#36000)
Bug Fixes¶
Follow BaseHook connection fields method signature in child classes (#36086)
5.9.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)
5.7.1¶
Bug Fixes¶
'PostgresOperator' should not overwrite 'SQLExecuteQueryOperator.template_fields' (#34969)
5.7.0¶
Note
This release of provider is only available for Airflow 2.5+ as explained in the Apache Airflow providers support policy.
Features¶
Add 'get_ui_field_behaviour()' method to PostgresHook (#34811)
Misc¶
Bump min airflow version of providers (#34728)
5.6.1¶
Misc¶
Improve modules import in Airflow providers by some of them into a type-checking block (#33754)
Use a single statement with multiple contexts instead of nested statements in providers (#33768)
Use literal dict instead of calling dict() in providers (#33761)
5.6.0¶
Features¶
openlineage, postgres: add OpenLineage support for Postgres (#31617)
Misc¶
Add deprecation info to the providers modules and classes docstring (#32536)
5.5.1¶
Note
This release dropped support for Python 3.7
Misc¶
Add note about dropping Python 3.7 for providers (#32015)
5.5.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)
5.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¶
PostgresHook: Added ON CONFLICT DO NOTHING statement when all target fields are primary keys (#26661)
Add SQLExecuteQueryOperator (#25717)
Rename schema to database in PostgresHook (#26744)
5.2.0¶
Features¶
Use only public AwsHook's methods during IAM authorization (#25424)
Unify DbApiHook.run() method with the methods which override it (#23971)
5.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.
4.1.0¶
Features¶
adds ability to pass config params to postgres operator (#21551)
Bug Fixes¶
Fix mistakenly added install_requires for all providers (#22382)
4.0.0¶
The URIs returned by Postgres get_uri()
returns postgresql://
instead
of postgres://
prefix which is the only supported prefix for the
SQLAlchemy 1.4.0+. Any usage of get_uri()
where postgres://
prefix
should be updated to reflect it.
Breaking changes¶
Replaces the usage of postgres:// with postgresql:// (#21205)
Features¶
Add more SQL template fields renderers (#21237)
Add conditional 'template_fields_renderers' check for new SQL lexers (#21403)
Misc¶
Support for Python 3.10
2.4.0¶
Features¶
19489 - Pass client_encoding for postgres connections (#19827)
Amazon provider remove deprecation, second try (#19815)
Bug Fixes¶
2.3.0¶
Features¶
Added upsert method on S3ToRedshift operator (#18027)
Bug Fixes¶
Fix example dag of PostgresOperator (#18236)
2.2.0¶
Features¶
Make schema in DBApiHook private (#17423)
Misc¶
Optimise connection importing for Airflow 2.2.0
2.1.0 (YANKED)¶
Warning
This release has been yanked with a reason: The postgres operator seem to conflict with earlier versions of Airflow
Features¶
Add schema as DbApiHook instance attribute (#16521)
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.
Features¶
PostgresHook: deepcopy connection to avoid mutating connection obj (#15412)
postgres_hook_aws_conn_id (#16100)
1.0.2¶
Do not forward cluster-identifier to psycopg2 (#15360)
1.0.1¶
Updated documentation and readme files. Added HowTo guide for Postgres Operator.
1.0.0¶
Initial version of the provider.