BigQuery Run Query Documentation
Overview
The BigQuery Run Query node is part of the BigQuery integration in the Vantage workflow engine. Execute a SQL query against BigQuery and return results.
This node uses the BigQuery API through Vantage's managed credential system — no manual token handling required.
Settings
Query
- Input Type: String
- Description: Standard SQL query to execute.
Project ID
- Input Type: String
How It Works
- Receives input data from upstream nodes through configured input ports.
- Authenticates with BigQuery using your connected credentials.
- Executes the API operation with the provided configuration and input data.
- Returns the result through the output port for downstream processing.
Error handling is built in — if the API call fails, the node throws a descriptive error with the failure reason.
Input and Output
- Input: Accepts data in object or array format from upstream nodes.
- Output: Returns the BigQuery API response as structured data.
Use Cases
Workflow Automation
Integrate BigQuery operations into multi-step workflows combining data from multiple sources, transformations, and conditional logic.
Scheduled Operations
Pair with the Schedule Trigger node to run BigQuery operations on a recurring basis.
Event-Driven Pipelines
Combine with other trigger nodes to react to events and automatically execute BigQuery actions.