BigQueryToMySqlOperator

Google

Fetches the data from a BigQuery table (alternatively fetch data for selected columns) and insert that data into a MySQL table.

View Source

Last Updated: Apr. 27, 2021

Access Instructions

Install the Google provider package into your Airflow environment.

Import the module into your DAG file and instantiate it with your desired params.

Parameters

dataset_tablestrA dotted .: the big query table of origin
selected_fieldsstrList of fields to return (comma-separated). If unspecified, all fields are returned.
gcp_conn_idstrreference to a specific Google Cloud hook.
delegate_tostrThe account to impersonate using domain-wide delegation of authority, if any. For this to work, the service account making the request must have domain-wide delegation enabled.
mysql_conn_idstrreference to a specific mysql hook
databasestrname of database which overwrite defined one in connection
replaceboolWhether to replace instead of insert
batch_sizeintThe number of rows to take in each batch
locationstrThe location used for the operation.
impersonation_chainUnion[str, Sequence[str]]Optional service account to impersonate using short-term credentials, or chained list of accounts required to get the access_token of the last account in the list, which will be impersonated in the request. If set as a string, the account must grant the originating account the Service Account Token Creator IAM role. If set as a sequence, the identities from the list must grant Service Account Token Creator IAM role to the directly preceding identity, with first account from the list granting this role to the originating account (templated).

Documentation

Fetches the data from a BigQuery table (alternatively fetch data for selected columns) and insert that data into a MySQL table.

Note

If you pass fields to selected_fields which are in different order than the order of columns already in BQ table, the data will still be in the order of BQ table. For example if the BQ table has 3 columns as [A,B,C] and you pass ‘B,A’ in the selected_fields the data would still be of the form 'A,B' and passed through this form to MySQL

Example:

transfer_data = BigQueryToMySqlOperator(
task_id='task_id',
dataset_table='origin_bq_table',
mysql_table='dest_table_name',
replace=True,
)

Example DAGs

Improve this module by creating an example DAG.

View Source
  1. Add an `example_dags` directory to the top-level source of the provider package with an empty `__init__.py` file.
  2. Add your DAG to this directory. Be sure to include a well-written and descriptive docstring
  3. Create a pull request against the source code. Once the package gets released, your DAG will show up on the Registry.

Was this page helpful?