To write data to the Google BigQuery, create a data object write operation based on the Google BigQuery data object. Configure the write operation properties to determine how the Data Integration Service must write data to the Google BigQuery. Add the write operation as a Write transformation in a mapping.

You can use a Google BigQuery data object read operation to look up data in a Google BigQuery table. You can add the data object read operation to a mapping as a lookup transformation. You can look up data from a Google BigQuery table in a mapping based on a lookup condition. You can configure a cached lookup operation to cache the lookup table on the Spark engine and an uncached lookup operation in the native environment.