Input
BigQuery Input
Runs a read-only standard-SQL query in Google BigQuery and turns the result into rows, every page of it.
When to use it
Use it for analytics data kept in BigQuery: event tables, GA4 exports, prepared views.
In a pipeline
BigQuery InputChart
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Google connection | select | Yes | Add a connection below |
| Project | text | — | Default: the service account's project |
| Query | textarea | Yes | SELECT event, COUNT(*) AS n FROM analytics.events GROUP BY event |
Example
Events per type
- Query=SELECT event, COUNT(*) AS n FROM analytics.events GROUP BY event
| event | n |
|---|---|
| signup | 412 |
| purchase | 97 |
Worth knowing
- It signs in with a Google service account connection (the same kind Google Sheets uses); give that account the BigQuery Job User and Data Viewer roles.
- Project defaults to the service account's own project; type another to bill the query there.
- Numbers, booleans and timestamps arrive typed; records and arrays arrive as they are.