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 | ✅ | - | - | Standard SQL query to be executed against BigQuery. Does not support Legacy SQL. |
Service Account | GOOGLE_APPLICATION_CREDENTIALS | Password | ✅ | - | - | JSON from a Google Cloud Service account key. |
YAML
Below is the YAML template for this Template and can be used in the Workflow YAML Editor.
CODE
source:
blueprint: Google BigQuery - Execute Query
inputs:
BIGQUERY_QUERY: null ## REQUIRED
GOOGLE_APPLICATION_CREDENTIALS: null ## REQUIRED
type: BLUEPRINT
guardrails:
retry_count: 1
retry_wait: 0h0m0s
runtime_cutoff: 1h0m0s
exclude_exit_code_ranges:
- '102'
- '200'
- '203'
- '205'