PowerExchange for Google BigQuery User Guide

10.4.0
- 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.1

Back Next

Rules and Guidelines for Google BigQuery Connection Modes

Simple Mode

Consider the following rules and guidelines when you configure a Google BigQuery connection to use simple connection mode:

If the Google BigQuery data object contains repeated columns, you cannot configure filters for these columns in a data object read operation.

If the Google BigQuery table contains more than one repeated column, you cannot preview data.

If the Google BigQuery data object contains repeated columns, you cannot configure update and delete operations for these columns in a data object write operation.

When you read data from a Google BigQuery source, you must not map more than one repeated column in a single mapping. You must create multiple mappings for each repeated column.

Hybrid Mode

Consider the following rules and guidelines when you configure a Google BigQuery connection to use hybrid connection mode:

If the Google BigQuery data object contains columns of the Record data type and repeated columns, you cannot configure filters for these columns in a data object read operation.

You cannot configure update and delete operations for columns of the Record data type and repeated columns.

You must select JSON (Newline Delimited) format as the data format of the staging file under the data object write operation advanced properties.

You cannot use CSV format as the data format of the staging file. The following CSV formatting options in the data object write operation advanced properties are not applicable:

Allow Quoted Newlines

Field Delimiter

Allow Jagged Rows

Complex Mode

Consider the following rules and guidelines when you configure a Google BigQuery connection to use complex connection mode:

When you configure a Google BigQuery connection to use complex connection mode, you cannot configure filters in a data object read operation.

You cannot configure update and delete operations.

You must select JSON (Newline Delimited) format as the data format of the staging file under the data object write operation advanced properties.

You cannot use CSV format as the data format of the staging file. The following CSV formatting options in the data object write operation advanced properties are not applicable:

Allow Quoted Newlines

Field Delimiter

Allow Jagged Rows

Google BigQuery Connections

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal