Streams data into BigQuery one record at a time without needing to run a load job.
HTTP request
POST https://bigquery.googleapis.com/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll
The URL uses gRPC Transcoding syntax.
Path parameters
Parameters | |
---|---|
projectId |
|
datasetId |
|
tableId |
|
Request body
The request body contains data with the following structure:
JSON representation | |
---|---|
{ "kind": [ string ], "skipInvalidRows": boolean, "ignoreUnknownValues": boolean, "templateSuffix": string, "rows": [ { "insertId": string, "json": { object } } ] } |
Fields | |
---|---|
kind[] |
|
skipInvalidRows |
|
ignoreUnknownValues |
|
templateSuffix |
|
rows[] |
|
rows[].insertId |
|
rows[].json |
|
Response body
If successful, the response body contains data with the following structure:
JSON representation | |
---|---|
{
"kind": string,
"insertErrors": [
{
"index": number,
"errors": [
{
object ( |
Fields | |
---|---|
kind |
|
insertErrors[] |
|
insertErrors[].index |
|
insertErrors[].errors[] |
|
Authorization Scopes
Requires one of the following OAuth scopes:
https://www.googleapis.com/auth/bigquery
https://www.googleapis.com/auth/cloud-platform
https://www.googleapis.com/auth/bigquery.insertdata
For more information, see the Authentication Overview.