Google BigQuery · Schema

JobConfiguration

AnalyticsBig DataCloudData WarehouseServerlessSQL

Properties

Name Type Description
jobType string The type of the job
query object Configuration for a query job
load object Configuration for a load job
extract object Configuration for an extract job
copy object Configuration for a copy job
View JSON Schema on GitHub

JSON Schema

google-bigquery-jobconfiguration-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/JobConfiguration",
  "title": "JobConfiguration",
  "type": "object",
  "properties": {
    "jobType": {
      "type": "string",
      "description": "The type of the job"
    },
    "query": {
      "type": "object",
      "description": "Configuration for a query job",
      "properties": {
        "query": {
          "type": "string",
          "description": "SQL query text"
        },
        "destinationTable": {
          "$ref": "#/components/schemas/TableReference"
        },
        "useLegacySql": {
          "type": "boolean",
          "description": "Whether to use legacy SQL dialect"
        }
      }
    },
    "load": {
      "type": "object",
      "description": "Configuration for a load job"
    },
    "extract": {
      "type": "object",
      "description": "Configuration for an extract job"
    },
    "copy": {
      "type": "object",
      "description": "Configuration for a copy job"
    }
  }
}