Skip to main content

​
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

1

Connect Google account

Go to Builder → Integrations → Google and authenticate
2

Add the BigQuery Reader node

Find it in Integrations → Google → BigQuery
3

Configure project and query

Specify your project ID and SQL query to execute

​
Configuration

​
project_id
string
required
Your Google Cloud project ID.
​
query
string
required
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