Google BigQuery - Execute Query

Overview

Execute any Standard SQL query against a Google BigQuery database. Perfect for creating multi-step SQL jobs, executing DML statements, or running scheduled queries.

Variables

Name	Reference	Type	Required	Default	Options	Description
Query	BIGQUERY_QUERY	Alphanumeric	✅	None	-	Standard SQL query to be executed against BigQuery. Does not support Legacy SQL.
Service Account	GOOGLE_APPLICATION_CREDENTIALS	Password	✅	None	-	JSON from a Google Cloud Service account key.
Project ID	BIGQUERY_PROJECT	Alphanumeric	➖	-	-
Location	BIGQUERY_LOCATION	Alphanumeric	➖	-	-

YAML

Below is the YAML template

YAML


source:
  template: Google BigQuery - Execute Query
  inputs:
    BIGQUERY_QUERY:
    GOOGLE_APPLICATION_CREDENTIALS:
    BIGQUERY_PROJECT:
    BIGQUERY_LOCATION:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 102
    - 200
    - 203
    - 205