Skip to content

Google Big Query

Node: googleBigQuery · Full type: n8n-nodes-base.googleBigQuery · Version: 2.1

Credentials

googleApi (alias: @google) / googleBigQueryOAuth2Api (alias: @google)

CREDENTIAL @google = googleApi "My Google Big Query"

Operations

executeQuery

No additional parameters.

insert

No additional parameters.

Common Parameters

Parameter Type Default Details
authentication options "oAuth2" oAuth2, serviceAccount

Parameter Details

options children:

Parameter Type Default Details
defaultDataset options ""
dryRun boolean false
includeSchema boolean false
location string ""
maximumBytesBilled string ""
maxResults number 1000
timeoutMs number 10000
rawOutput boolean false
useLegacySql boolean false
returnAsNumbers boolean false
queryParameters fixedCollection {...} groups: namedParameters

fieldsUi children:

values group:

Parameter Type Default Details
fieldId options ""
fieldValue string ""

Example

NODE "googleBigQuery" @google AS "Google Big Query" {
  operation: "executeQuery"
}