Google BigQuery · Schema

TableDataInsertAllRequest

AnalyticsBig DataCloudData WarehouseServerlessSQL

Properties

Name Type Description
kind string The resource type
skipInvalidRows boolean Whether to insert rows that contain values that do not match the schema
ignoreUnknownValues boolean Whether to accept rows with fields not matching the schema
rows array The rows to insert
View JSON Schema on GitHub

JSON Schema

google-bigquery-tabledatainsertallrequest-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/TableDataInsertAllRequest",
  "title": "TableDataInsertAllRequest",
  "type": "object",
  "properties": {
    "kind": {
      "type": "string",
      "description": "The resource type"
    },
    "skipInvalidRows": {
      "type": "boolean",
      "description": "Whether to insert rows that contain values that do not match the schema"
    },
    "ignoreUnknownValues": {
      "type": "boolean",
      "description": "Whether to accept rows with fields not matching the schema"
    },
    "rows": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "insertId": {
            "type": "string",
            "description": "A unique ID for deduplication"
          },
          "json": {
            "type": "object",
            "description": "A JSON object with a row of data"
          }
        }
      },
      "description": "The rows to insert"
    }
  }
}