Google BigQuery component

Google BigQuery

Integration component to interact with Google BigQuery.

Description

Integration component to interact with Google BigQuery using @google-cloud/bigquery client library version 5.2.0 (API).

Credentials

Service Account - Set of credentials (project ID, private key, etc) provided by Google.

More information on how to generate credentials you can find here.

After you perform all authentication steps described above just copy and paste content of an authentication JSON file as-is to the field Service Account credentials.

It should look like this:

{
  "type": "service_account",
  "project_id": "projectname",
  "private_key_id": "ds67f57s6df5sd76f57s6df57sdf67sdf76df",
  "private_key": "PRIVATE_KEY",
  "client_email": "email",
  "client_id": "2348238472834782348723",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url": "cert_url"
}

Technical Notes

The technical notes page gives some technical details about Google BigQuery component like changelog and completeness matrix.

Triggers

This component has no trigger functions. This means it will not be accessible to select as a first component during the integration flow design.

Actions

Query

Performs a query provided by user.

Expected input metadata

Input metadata include query options according to documentations. The query option is required.

{
  "type": "object",
  "required": true,
  "properties": {
    "query": {
      "type": "string",
      "required": true
    }
  }
}

Expected output metadata 

{
  "type": "object",
  "required": true,
  "properties": {
    "result": {
      "required": true,
      "type": "array"
    }
  }
}

Action Limitations

The query options are an experimental feature and correct behavior is not guaranteed. Only query, location, dryRun, useQueryCache, useLegacySql, parameterMode,maximumBytesBilled options were tested.

BigQuery documentation