PowerExchange for Google BigQuery User Guide

10.5.3
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0

Back Next

Google BigQuery Lookup Overview

You can use a Google BigQuery data object read operation to look up data in a Google BigQuery table.

You can add a Google BigQuery data object read operation as a lookup in a mapping. You can then configure a lookup condition to look up data from the Google BigQuery table. You can configure the following types of lookups on a Google BigQuery table:

Cached Lookup: You can configure a connected cached lookup operation to cache the lookup data on the Spark engine or in the native environment.
Uncached Lookup: You can configure an connected uncached lookup operation in the native environment when you do not want the Data Integration Service to cache the lookup data.
When you configure an uncached lookup operation, the Data Integration Service does not consider the Google BigQuery data object read advanced properties. However, you must provide the Google BigQuery dataset name in the Google BigQuery data object read advanced properties to validate the read operation.

For more information about cached lookup, see

"Lookup Transformation" in the Developer Transformation Guide.

Google BigQuery Lookup

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal