Google BigQuery
Discover more about the Google BigQuery connector and how to use it on the Digibee Integration Platform.
Last updated
Discover more about the Google BigQuery connector and how to use it on the Digibee Integration Platform.
Last updated
The content of this documentation is under revision and may change. We appreciate your understanding as we work to improve it.
Google BigQuery queries data warehouse from Google BigQuery for analytics.
Take a look at the configuration parameters for the connector. Parameters supported by Double Braces expressions are marked with (DB).
| Parameter | Description | Default value | Data type |
|---|---|---|---|
| Parameter | Description | Default value | Data type |
|---|---|---|---|
| Parameter | Description | Default value | Data type |
|---|---|---|---|
| Parameter | Description | Default value | Data type |
|---|---|---|---|
Dynamic Account
When active, the connector will use the account dynamically. Otherwise, it will use the account statically.
False
Boolean
Account Name (DB)
The name of the dynamic account used by the connector. This account must have been previously configured in a Store Account connector in the pipeline for this process to take effect. It is only available if the Dynamic Account parameter is active.
N/A
String
Account
The account used by the connector. It is only available if the Dynamic Account parameter is inactive.
N/A
Account
Project Id (DB)
Google Cloud Project ID.
N/A
String
Dataset Id (DB)
BigQuery Dataset ID.
N/A
String
Fail On Error
If the option is activated, the pipeline's execution with an error will be interrupted. Otherwise, the pipeline execution proceeds, but the result will show a false value for the "success" property.
False
Boolean
Table Id (DB)
BigQuery table ID.
N/A
String
Use As Insert Id (DB)
Field name to use as insert ID.
N/A
String
Body (DB)
The body, if applicable.
{}
JSON
Table Suffix (DB)
Table suffix to use when inserting data.
N/A
String
Table Id (DB)
Table ID where data will be submitted. If specified will override endpoint configuration.
N/A
String
Insert Id (DB)
Insert ID to use when inserting data.
N/A
String
Partition Decorator (DB)
Partition decorator to indicate partition to use when inserting data.
N/A
String
Documentation
Section for documenting any necessary information about the connector configuration and business rules.
N/A
String