PowerExchange for Google BigQuery User Guide

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

Back Next

Lookup Properties

Specify the lookup properties to look up a Google BigQuery table. You can configure a lookup condition to look up data from the Google BigQuery table.

To configure a lookup condition, you can select one of the following options in the

Specify by

property:

Value

: Select this option if you want to configure a lookup condition using the column name.

Parameter

: Select this option if you want to parameterize the lookup condition.

The following table describes the lookup properties that you can specify for a Google BigQuery lookup if you select the

Value

option:

Property	Description
Lookup Column	The name of the columns that you want to look up.
Operator	Operators that you can use to filter records. You can select one of the following operators: =, !=, <=, >=, and
Input Port	The input source port.

The following table describes the lookup properties that you can specify for a Google BigQuery lookup if you select the

Parameter

option:

Property	Description
Parameter	The name of the parameter that you want to use to look up. You can also create a new parameter. Click New to create a new parameter. Enter the parameter name and specify an expression in the New Parameter dialog box. Click Validate to check if the expression that you specified is valid or not.

Rename Saved Search

Table of Contents

PowerExchange for Google BigQuery User Guide

PowerExchange for Google BigQuery User Guide

Lookup Properties

Lookup Properties