airflow.providers.google.cloud.transfers.bigquery_to_mysql

This module contains Google BigQuery to MySQL operator.

Module Contents

Classes

BigQueryToMySqlOperator

Fetch data from a BigQuery table (alternatively fetch selected columns) and insert it into a MySQL table.

class airflow.providers.google.cloud.transfers.bigquery_to_mysql.BigQueryToMySqlOperator(*, mysql_table=None, target_table_name=None, mysql_conn_id='mysql_default', dataset_id=None, table_id=None, **kwargs)[source]

Bases: airflow.providers.google.cloud.transfers.bigquery_to_sql.BigQueryToSqlBaseOperator

Fetch data from a BigQuery table (alternatively fetch selected columns) and insert it into a MySQL table.

See also

For more information on how to use this operator, take a look at the guide: Operator

Parameters
  • mysql_table (str | None) – target MySQL table, use dot notation to target a specific database. It is deprecated: use target_table_name instead. (templated)

  • target_table_name (str | None) – target MySQL table. It takes precedence over mysql_table. (templated)

  • mysql_conn_id (str) – Reference to mysql connection id.

template_fields: Sequence[str] = ()[source]
get_sql_hook()[source]

Return a concrete SQL Hook (a PostgresHook for instance).

Was this entry helpful?