Google BigQuery Connectors > Part III: Data Integration with Google BigQuery Connector > Mappings and Mapping Tasks with Google BigQuery > Upsert Task Operation
  

Upsert Task Operation

When you perform an upsert operation on a Google BigQuery target, you must configure the upsert fields for the target table. You can use an ID field for standard objects. Ensure that you include the upsert field in the field mappings for the task.

Rules and Guidelines

Consider the following rules and guidelines when you perform an upsert operation on a Google BigQuery target: