Optional. The resource type of the response. The value is not checked at the backend. Historically, it has been set to "bigquery#tableDataInsertAllRequest" but you are not required to set it.
skipInvalidRows
boolean
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.
ignoreUnknownValues
boolean
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.
templateSuffix
string
Optional. 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.
Insertion ID for best-effort deduplication. This feature is not recommended, and users seeking stronger insertion semantics are encouraged to use other mechanisms such as the BigQuery Write API.
Optional. Unique request trace id. Used for debugging purposes only. It is case-sensitive, limited to up to 36 ASCII characters. A UUID is recommended.
Response body
Describes the format of a streaming insert response.
If successful, the response body contains data with the following structure:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-02 UTC."],[[["\u003cp\u003eThis API streams data into BigQuery one record at a time using a POST request to a specific URL structure: \u003ccode\u003ehttps://bigquery.googleapis.com/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe request body accepts a JSON format that allows you to send multiple rows of data, with each row having an \u003ccode\u003einsertId\u003c/code\u003e for deduplication and a \u003ccode\u003ejson\u003c/code\u003e field for the actual row data.\u003c/p\u003e\n"],["\u003cp\u003eOptional fields in the request body include \u003ccode\u003eskipInvalidRows\u003c/code\u003e to allow partial success, \u003ccode\u003eignoreUnknownValues\u003c/code\u003e to handle schema mismatches, \u003ccode\u003etemplateSuffix\u003c/code\u003e for template-based table inserts, and a \u003ccode\u003etraceId\u003c/code\u003e for debugging.\u003c/p\u003e\n"],["\u003cp\u003eThe response body provides a \u003ccode\u003ekind\u003c/code\u003e to identify it as a \u003ccode\u003ebigquery#tableDataInsertAllResponse\u003c/code\u003e along with an array of \u003ccode\u003einsertErrors\u003c/code\u003e that, when populated, detail specific issues encountered with certain rows.\u003c/p\u003e\n"],["\u003cp\u003eAuthorization for this API requires one of the following OAuth scopes: \u003ccode\u003ehttps://www.googleapis.com/auth/bigquery\u003c/code\u003e, \u003ccode\u003ehttps://www.googleapis.com/auth/cloud-platform\u003c/code\u003e, or \u003ccode\u003ehttps://www.googleapis.com/auth/bigquery.insertdata\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# Method: tabledata.insertAll\n\n- [HTTP request](#body.HTTP_TEMPLATE)\n- [Path parameters](#body.PATH_PARAMETERS)\n- [Request body](#body.request_body)\n - [JSON representation](#body.request_body.SCHEMA_REPRESENTATION)\n- [Response body](#body.response_body)\n - [JSON representation](#body.TableDataInsertAllResponse.SCHEMA_REPRESENTATION)\n- [Authorization scopes](#body.aspect)\n- [Try it!](#try-it)\n\nStreams data into BigQuery one record at a time without needing to run a load job.\n\n### HTTP request\n\n`POST https://bigquery.googleapis.com/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll`\n\nThe URL uses [gRPC Transcoding](https://google.aip.dev/127) syntax.\n\n### Path parameters\n\n### Request body\n\nThe request body contains data with the following structure:\n\n### Response body\n\nDescribes the format of a streaming insert response.\n\nIf successful, the response body contains data with the following structure:\n\n### Authorization scopes\n\nRequires one of the following OAuth scopes:\n\n- `https://www.googleapis.com/auth/bigquery`\n- `https://www.googleapis.com/auth/cloud-platform`\n- `https://www.googleapis.com/auth/bigquery.insertdata`\n\nFor more information, see the [Authentication Overview](/docs/authentication#authorization-gcp)."]]
