BigQuery Insert Rows
Overview
The BigQuery Insert Rows node inserts data into a BigQuery table. It uses SQL INSERT for standard workloads and falls back to the streaming insert API for large datasets (>5000 rows). Supports auto-creating the dataset and table if they don't exist.
Category
BigQuery — bigquery/insertRows
Settings
| Setting | Type | Default | Description |
|---|---|---|---|
| projectId | String | — | GCP project ID |
| datasetId | String | — | BigQuery dataset ID |
| tableId | String | — | BigQuery table ID |
| autoCreateTable | Boolean | false | Create dataset + table if they don't exist |
Inputs & Outputs
- input1 — Data rows to insert
- output1 — Insert result (row count, errors)
Integration Requirement
Requires an active BigQuery integration configured in Settings → Integrations.