You cannot configure an uncached lookup transformation in a Google BigQuery session.

When you configure a Lookup transformation, you must select the Google BigQuery lookup table for the Lookup transformation in the

Source

tab or the

Source Qualifier

tab.

When you use a Google BigQuery connection in simple mode and the Lookup table contains multiple columns of repeated data type, you must specify one of the columns of repeated data type in the lookup condition and delete the remaining columns of repeated data type in the Lookup transformation and in the source qualifier.

When you configure the

On multiple matches

property for a Lookup trasformation, the

Return first row

or

Return last row

options are not applicable.