apache-airflow-providers-mysql

Changelog¶

6.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 MySQL provider package. The following breaking changes were introduced:

Operators
- Remove airflow.providers.mysql.operators.mysql.MySqlOperator. Please use airflow.providers.common.sql.operators.sql.SQLExecuteQueryOperator. Also, you can provide hook_params={‘schema’: <database>}.

Remove Provider Deprecations in MySQL (#44665)

Bug Fixes¶

Fix error file not found. tmp file is deleted before inserting rows to DB in VerticaToMySQLOperator bulk (#44028)

Misc¶

Bump minimum Airflow version in providers to Airflow 2.9.0 (#44956)
Update DAG example links in multiple providers documents (#44034)
Add basic asyncio support (#43944)

5.7.4¶

Misc¶

Add support for semicolon stripping to DbApiHook, PrestoHook, and TrinoHook (#41916)
Explain how to use uv with airflow virtualenv and make it works (#43604)

5.7.3¶

Misc¶

Improve the cursor type definition of mysql (#43376)

5.7.2¶

Misc¶

Rename dataset related python variable names to asset (#41348)

5.7.1¶

Misc¶

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

5.7.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.6.3¶

Misc¶

Clean up remaining getattr connection DbApiHook (#40665)

5.6.2¶

Misc¶

implement per-provider tests with lowest-direct dependency resolution (#39946)
Resolving mysql deprecated operator warnings (#39725)

5.6.1¶

Misc¶

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

5.6.0¶

Note

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

Misc¶

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

5.5.4¶

Misc¶

Unify 'aws_conn_id' type to always be 'str | None' (#37768)
Implement AIP-60 Dataset URI formats (#37005)

5.5.3¶

Misc¶

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

5.5.2¶

Misc¶

Bump min version of mysql-connector-python (#36668)

5.5.1¶

Bug Fixes¶

Sanitize filenames in MySQLHook (#33328)

5.5.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.4.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)

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

5.3.0¶

Features¶

Add init_command parameter to MySqlHook (#33359)
Add 'local_infile' parameter to 'S3ToMySqlOperator' (#33459)

5.2.1¶

This release brings back mysql-connector-python as required dependency of the provider - since 8.1.0 version has been released with Protobuf 4 support, removing dependency conflicts with other providers.

Misc¶

Bring back mysql-connector-python as required depednency (#32989)

5.2.0¶

Features¶

Add OpenLineage support for MySQL. (#31609)

Misc¶

Add deprecation info to the providers modules and classes docstring (#32536)
Add default port to Openlineage authority method. (#32828)

5.1.1¶

Note

This release dropped support for Python 3.7

Misc¶

Replace unicodecsv with standard csv library (#31693)

5.1.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.0.0¶

Breaking changes¶

Warning

If you are using mysql-connector-python please note that starting this release it is an extra option. The library will not be installed by default.

Remove mysql-connector-python (#30487)

4.0.2¶

Misc¶

Use MariaDB client binaries in arm64 image for support MySQL backend (#29519)

4.0.1¶

Bug Fixes¶

Fixed MyPy errors introduced by new mysql-connector-python (#28995)

4.0.0¶

Breaking Changes¶

You can no longer pass “local_infile” as extra in the connection. You should pass it instead as hook’s “local_infile” parameter when you create the MySqlHook (either directly or via hook_params).

Move local_infile option from extra to hook parameter (#28811)

3.4.0¶

Features¶

Allow SSL mode in MySQL provider (#27717)

Bug fixes¶

Bump common.sql provider to 1.3.1 (#27888)

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¶

Add SQLExecuteQueryOperator (#25717)

3.2.1¶

Misc¶

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

3.2.0¶

Features¶

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

3.1.0¶

Features¶

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

Bug Fixes¶

Close the MySQL connections once operations are done. (#24508)

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.

2.2.3¶

Bug Fixes¶

Fix mistakenly added install_requires for all providers (#22382)

2.2.2¶

Misc¶

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

2.2.1¶

Misc¶

Support for Python 3.10
Make DbApiHook use get_uri from Connection (#21764)
Update MySqlOperator example dag (#21434)

2.2.0¶

Add more SQL template fields renderers (#21237)
Add conditional 'template_fields_renderers' check for new SQL lexers (#21403)

Misc¶

Refactor vertica_to_mysql to make it more 'mypy' friendly (#20618)

2.1.1¶

Misc¶

Optimise connection importing for Airflow 2.2.0

2.1.0¶

Features¶

Added template_fields_renderers for MySQL Operator (#16914)
Extended template_fields_renderers for MySQL provider (#16987)
Parse template parameters field for MySQL operator (#17080)

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.