Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Google BigQuery
  3. PowerExchange for Google BigQuery Configuration
  4. Google BigQuery Connections
  5. PowerExchange for Google BigQuery Data Objects
  6. PowerExchange for Google BigQuery Mappings
  7. Google BigQuery Lookup
  8. Google BigQuery Run-Time Processing
  9. Appendix A: Google BigQuery Data Type Reference

PowerExchange for Google BigQuery User Guide

PowerExchange for Google BigQuery User Guide

General Properties

General Properties

The general properties display the name and description of the Google BigQuery lookup.
The following table describes the general properties that you can view and edit for a Google BigQuery lookup:
Property
Description
Name
Name of the Google BigQuery lookup.
Description
Description of the Google BigQuery lookup.
Physical Data Object
Name of the Google BigQuery data object read operation.
On multiple matches
Determines which row the Google BigQuery lookup returns when it finds multiple rows that match the lookup condition.
You can select one of the following options:
  • Return any row
  • Return all rows
  • Report error
The
Return first row
or
Return last row
options are not applicable for PowerExchange for Google BigQuery.

0 COMMENTS

We’d like to hear from you!