What does this node do?
The BigQuery Reader node executes SQL queries against Google BigQuery and returns the results. Perfect for analytics and large-scale data processing.
Quick setup
Connect Google account
Go to Builder → Integrations → Google and authenticate
Add the BigQuery Reader node
Find it in Integrations → Google → BigQuery
Configure project and query
Specify your project ID and SQL query to execute
Configuration
Your Google Cloud project ID.
SQL query to execute.SELECT date, campaign, SUM(revenue) as total
FROM `project.dataset.table`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
GROUP BY date, campaign
Output
{
"rows": [
{"date": "2024-01-15", "campaign": "Brand", "total": 15000}
],
"totalRows": 50,
"schema": [...]
}
Best practices
- Use parameterized queries for dynamic values
- Limit results for large tables
- Set appropriate timeout for long queries
