BigQuery Reader

Query data from Google BigQuery

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

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