Bigquery.tabledata.insert All

Streams data into BigQuery one record at a time without needing to run a load job. Requires the WRITER dataset role.

POST/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll

Use it in a workflow

Add a step and choose the BigQuery connector.
Pick the Bigquery.tabledata.insert All action (under tabledata).
Fill in the fields below, then reference the result from later steps as {{bigqueryTabledataInsertAll.response.data}}.

Request

Path parameters

projectIdstringrequired

Project ID of the destination table.

datasetIdstringrequired

Dataset ID of the destination table.

tableIdstringrequired

Table ID of the destination table.

Query parameters

altstring

Data format for the response.

One ofjson

fieldsstring

Selector specifying which fields to include in a partial response.

keystring

API key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token.

oauth_tokenstring

OAuth 2.0 token for the current user.

prettyPrintboolean

Returns response with indentations and line breaks.

quotaUserstring

An opaque string that represents a user for quota purposes. Must not exceed 40 characters.

userIpstring

Deprecated. Please use quotaUser instead.

Request body

Enter the body as JSON in the step's Body field.

ignoreUnknownValuesboolean

[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.

kindstring

The resource type of the response.

Default "bigquery#tableDataInsertAllRequest"

rowsarray<object>

The rows to insert.

insertIdstring

[Optional] A unique ID for each row. BigQuery uses this property to detect duplicate insertion requests on a best-effort basis.

jsonobject

Represents a single JSON object.

skipInvalidRowsboolean

[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.

templateSuffixstring

If 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.

json

{
  "ignoreUnknownValues": false,
  "kind": "bigquery#tableDataInsertAllRequest",
  "rows": [
    {
      "insertId": "string",
      "json": {}
    }
  ],
  "skipInvalidRows": false,
  "templateSuffix": "string"
}

Response

Returns 200 with an object. Read it in later steps with {{bigqueryTabledataInsertAll.response.data.<field>}}.

insertErrorsarray<object>

An array of errors for rows that were not inserted.

errorsarray<object>4 fields

Error information for the row indicated by the index property.

indexinteger (uint32)

The index of the row that error applies to.

kindstring

The resource type of the response.

Default "bigquery#tableDataInsertAllResponse"

json

{
  "insertErrors": [
    {
      "errors": [
        {
          "debugInfo": "string",
          "location": "string",
          "message": "string",
          "reason": "string"
        }
      ],
      "index": 0
    }
  ],
  "kind": "bigquery#tableDataInsertAllResponse"
}

Need more? See the BigQuery guide for connection setup and behaviour shared by every action.

Was this page helpful?