Google BigQuery Standard SQL

Discover more about the Google BigQuery Standard SQL connector and how to use it on the Digibee Integration Platform.

Important information:

• This documentation is currently available only in English but will soon be translated into Portuguese.

• The content is under revision and may change. We appreciate your understanding as we work to improve the documentation.

Access Google Cloud BigQuery service using SQL queries

Parameters

Take a look at the configuration options for the component. Parameters supported by Double Braces expressions are marked with (DB).

Required Tab

Parameter	Description	Default value	Data type
Dynamic Account	When activated, the connector will use the account dynamically. When deactivated, it’ll use the account statically.	false	boolean
Account Name DB	The name of the account that is generated dynamically via the Store Account connector.		string
Account	Sets the account to be used by the connector.	N/A	string
Project Id DB	Google Cloud Project Id	N/A	string
Query String DB	BigQuery standard SQL query	N/A	string
Fail On Error	If true will stop pipeline with an error, if false will let the pipeline continue but the output will show a property success with value false	false	boolean

Headers Tab

Parameter	Description	Default value	Data type
CamelGoogleBigQueryTranslatedQuery DB	Preprocessed query text	N/A	string

Successful executions should output at least a property "success": true