To learn more, visit the GCP documentation.

​
Basic Parameters​

ParameterDescription
Dataset IDDataset ID of the destination table.
Project IDProject ID of the destination table.
RowsThe rows to insert.
Table IDTable ID of the destination table.

​
Advanced Parameters​

ParameterDescription
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.
KindThe 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 SuffixIf specified, treats the destination table as a base template, and inserts the rows into an instance table named “{destination}{templateSuffix}”. 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"}

​
Workflow Library Example​

Insert All Bigquery Table Data with Gcp and Send Results Via Email

Preview this Workflow on desktop

Was this page helpful?

Get Storage BucketInsert BigQuery Dataset