Output
BigQuery Output
Appends the rows to an existing BigQuery table with streaming inserts.
When to use it
Use it to publish events or results to BigQuery for analysis.
In a pipeline
File InputBigQuery Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Google connection | select | Yes | Add a connection below |
| Project | text | — | Default: the service account's project |
| Dataset | text | Yes | analytics |
| Table | text | Yes | events |
Example
Append events
- Dataset=analytics
- Table=events
| event | at |
|---|---|
| signup | 2026-10-17 09:12 |
| event | at |
|---|---|
| signup | 2026-10-17 09:12 |
Worth knowing
- The table must exist; column names must match its fields. Give the service account the BigQuery Data Editor role.
- Rows go 500 per request; if BigQuery rejects rows the node stops and names the first problem (rows already sent stay).
- Streaming inserts cannot join a Transaction Control.