apache-airflow-providers-mysql

Content

Guides

References

Resources

Commits

Package apache-airflow-providers-mysql

MySQL

Release: 4.0.1

Provider package

This is a provider package for mysql provider. All classes for this provider package are in airflow.providers.mysql python package.

Installation

You can install this package on top of an existing Airflow 2 installation (see Requirements below) for the minimum Airflow version supported) via pip install apache-airflow-providers-mysql

Requirements

PIP package

Version required

apache-airflow

>=2.3.0

apache-airflow-providers-common-sql

>=1.3.1

mysql-connector-python

>=8.0.11; platform_machine != "aarch64"

mysqlclient

>=1.3.6; platform_machine != "aarch64"

Cross provider package dependencies

Those are dependencies that might be needed in order to use all the features of the package. You need to install the specified provider packages in order to use them.

You can install such cross-provider dependencies when installing from PyPI. For example:

pip install apache-airflow-providers-mysql[amazon]

Dependent package

Extra

apache-airflow-providers-amazon

amazon

apache-airflow-providers-common-sql

common.sql

apache-airflow-providers-presto

presto

apache-airflow-providers-trino

trino

apache-airflow-providers-vertica

vertica

Downloading official packages

You can download officially released packages and verify their checksums and signatures from the Official Apache Download site

The version of MySQL server has to be 5.6.4+. The exact version upper bound depends on the version of mysqlclient package. For example, mysqlclient 1.3.12 can only be used with MySQL server 5.6.4 through 5.7.

Changelog

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

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

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.

Bug Fixes

1.1.0

Features

  • Adds 'Trino' provider (with lower memory footprint for tests) (#15187)

  • A bunch of template_fields_renderers additions (#15130)

Bug fixes

  • Fix autocommit calls for mysql-connector-python (#14869)

1.0.2

Bug fixes

  • MySQL hook respects conn_name_attr (#14240)

1.0.1

Updated documentation and readme files.

1.0.0

Initial version of the provider.

Was this entry helpful?