PowerExchange for Google BigQuery User Guide

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

Back Next

Rules and Guidelines for PowerExchange for Google BigQuery Data Object Operations

Use the following rules and guidelines when you configure a PowerExchange for Google BigQuery data object read and write operation:

You must define a primary key in the source table and target table for update and delete operations.

If you do not define a primary key in the target table, the mapping fails to update records in or delete records from the target table.

You cannot read hierarchical data from a Google BigQuery source, convert the hierarchical input to relational output, and write data to relational targets.

You cannot perform more than one operation with a pre SQL or post SQL command.

If you perform an UPDATE or DELETE operation with a pre SQL or post SQL command, you must specify the following parameter in the pre SQL configuration or post SQL configuration:

UseLegacySQL:False

PowerExchange for Google BigQuery Data Objects

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal