A mapping defines reusable data flow logic that you can use in mapping tasks.

When you create a mapping, you define the Source, Target, and Lookup transformations to represent a

Google BigQuery V2

object. Use the Mapping Designer in

Data Integration

to add the Source, Target, or Lookup transformations in the mapping canvas and configure the

Google BigQuery V2

source, target, and lookup properties.

In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced functionality.

The

Google BigQuery V2

Connector uses Spark BigQuery connector library to write the data in a mapping in advanced mode. This library utilizes the Google BigQuery Storage API to directly write the data into Google BigQuery and does not use Google Cloud Storage for intermediate staging.

You can use

Monitor

to monitor the jobs.