BigQuery Insert Rows Documentation

Overview

The BigQuery Insert Rows node is part of the BigQuery integration in the Vantage workflow engine. Insert rows into a BigQuery table.

This node uses the BigQuery API through Vantage's managed credential system — no manual token handling required.

Settings

Dataset ID

• Input Type: String

Table ID

• Input Type: String

How It Works

1. Receives input data from upstream nodes through configured input ports.
2. Authenticates with BigQuery using your connected credentials.
3. Executes the API operation with the provided configuration and input data.
4. Returns the result through the output port for downstream processing.

Error handling is built in — if the API call fails, the node throws a descriptive error with the failure reason.

Input and Output

• Input: Accepts data in object or array format from upstream nodes.
• Output: Returns the BigQuery API response as structured data.

Use Cases

Workflow Automation

Integrate BigQuery operations into multi-step workflows combining data from multiple sources, transformations, and conditional logic.

Scheduled Operations

Pair with the Schedule Trigger node to run BigQuery operations on a recurring basis.

Event-Driven Pipelines

Combine with other trigger nodes to react to events and automatically execute BigQuery actions.