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