BigQueryUpdateTableOperator

Google

This operator is used to update table for your Project in BigQuery. Use fields to specify which fields of table to update. If a field is listed in fields and is None in table, it will be deleted.

View Source

Last Updated: Mar. 22, 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_idThe id of dataset. Don't need to provide, if datasetId in table_reference.
table_idstrThe id of table. Don't need to provide, if tableId in table_reference.
table_resourceDict[str, Any]Dataset resource that will be provided with request body. https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#resource
fieldsList[str]The fields of table to change, spelled as the Table properties (e.g. "friendly_name").
project_idstrThe name of the project where we want to create the table. Don't need to provide, if projectId in table_reference.
gcp_conn_idstr(Optional) The connection ID used to connect to Google Cloud.
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.
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

This operator is used to update table for your Project in BigQuery. Use fields to specify which fields of table to update. If a field is listed in fields and is None in table, it will be deleted.

See also

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

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?