Google BigQuery
What It Is
The Google BigQuery connection connects your BigQuery data warehouse to Duvo, enabling your assignments to query and analyze large datasets on your behalf. This is a user-configured connection—you'll need to provide your service account credentials before your assignments can use it.
What It Can Do
Query Execution
Run SQL queries against your BigQuery datasets
Retrieve and process query results
Execute parameterized queries
Data Exploration
List available datasets and tables
Explore table schemas and column definitions
Preview table data
Analysis
Aggregate and summarize large datasets
Pull business metrics and KPIs
Extract data for reports and workflows
Why It Matters
BigQuery is Google Cloud's serverless data warehouse, designed for fast SQL analytics over massive datasets. This connection allows assignments to:
Access enterprise data — Query your data warehouse directly from workflows
Drive decisions with data — Pull real-time metrics to inform automated actions
Eliminate manual exports — No more downloading CSVs or running ad-hoc queries
Scale analysis — Leverage BigQuery's processing power within your automations
When to Use It
Use the Google BigQuery connection when your assignment needs to:
Pull business metrics, sales data, or customer analytics
Generate data-driven reports from warehouse data
Validate information before making business decisions
Combine warehouse data with other systems in a workflow
Monitor thresholds and trigger actions based on data conditions
How It Works
Connect the connection — Provide your Google Cloud service account JSON credentials
Configure access — Specify which project and datasets to query
Build your assignment — Add BigQuery actions to your automation
Query data — Your assignment can now execute SQL queries and retrieve results
Key Benefits
Serverless analytics — Query petabytes of data without infrastructure management
Real-time insights — Access current data rather than relying on static exports
SQL flexibility — Execute any read query to get exactly the data you need
Secure access — Uses service account permissions for controlled data access
Data-driven automation — Make intelligent workflow decisions based on warehouse data
Last updated