Insert All BigQuery Table Data

External DocumentationTo learn more, visit the GCP documentation.

Parameter	Description
Dataset ID	Dataset ID of the destination table.
Project ID	Project ID of the destination table.
Rows	The rows to insert.
Table ID	Table ID of the destination table.

Parameter

Description

Dataset ID

Dataset ID of the destination table.

Project ID

Project ID of the destination table.

Rows

The rows to insert.

Table ID

Table ID of the destination table.

Advanced Parameters

Parameter	Description
Ignore Unknown Values	[Optional] Accept rows that contain values that do not match the schema. The unknown values are ignored. Default is false, which treats unknown values as errors.
Kind	The resource type of the response.
Skip Invalid Rows	[Optional] Insert all valid rows of a request, even if invalid rows exist. The default value is false, which causes the entire request to fail if any invalid rows exist.
Template Suffix	If specified, treats the destination table as a base template, and inserts the rows into an instance table named "". BigQuery will manage creation of the instance table, using the schema of the base template table. See https://cloud.google.com/bigquery/streaming-data-into-bigquery#template-tables for considerations when working with templates tables.

Example Output

{
	"insertErrors": [
		{
			"errors": [
				{
					"debugInfo": "Debugging information. This property is internal to Google and should not be used.",
					"location": "Specifies where the error occurred, if present.",
					"message": "A human-readable description of the error.",
					"reason": "A short error code that summarizes the error."
				}
			],
			"index": 0
		}
	],
	"kind": "bigquery#tableDataInsertAllResponse"
}

Integrations

Basic Parameters

Advanced Parameters

Example Output

Workflow Library Example

​Basic Parameters

​Advanced Parameters

​Example Output

​Workflow Library Example

Basic Parameters

Advanced Parameters

Example Output

Workflow Library Example