Google BigQuery · JSON Structure

Google Bigquery Structure

Structural overview of the Google BigQuery API surface; extracted from openapi/.

Type: Properties: 0
AnalyticsBig DataCloudData WarehouseServerlessSQL

Google Bigquery Structure is a JSON Structure definition published by Google BigQuery.

Meta-schema:

JSON Structure

Raw ↑
{
  "provider": "Google BigQuery",
  "providerId": "google-bigquery",
  "kind": "json-structure",
  "description": "Structural overview of the Google BigQuery API surface; extracted from openapi/.",
  "schemaCount": 25,
  "operationCount": 30,
  "schemas": [
    {
      "name": "Dataset",
      "type": "object",
      "propertyCount": 9,
      "required": []
    },
    {
      "name": "DatasetReference",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "DatasetList",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "Table",
      "type": "object",
      "propertyCount": 12,
      "required": []
    },
    {
      "name": "TableReference",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "TableSchema",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "TableFieldSchema",
      "type": "object",
      "propertyCount": 5,
      "required": [
        "name",
        "type"
      ]
    },
    {
      "name": "TableList",
      "type": "object",
      "propertyCount": 4,
      "required": []
    },
    {
      "name": "TableDataList",
      "type": "object",
      "propertyCount": 4,
      "required": []
    },
    {
      "name": "TableDataInsertAllRequest",
      "type": "object",
      "propertyCount": 4,
      "required": []
    },
    {
      "name": "TableDataInsertAllResponse",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "Job",
      "type": "object",
      "propertyCount": 6,
      "required": []
    },
    {
      "name": "JobReference",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "JobConfiguration",
      "type": "object",
      "propertyCount": 5,
      "required": []
    },
    {
      "name": "JobStatus",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "JobList",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "JobCancelResponse",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "QueryRequest",
      "type": "object",
      "propertyCount": 6,
      "required": [
        "query"
      ]
    },
    {
      "name": "QueryResponse",
      "type": "object",
      "propertyCount": 8,
      "required": []
    },
    {
      "name": "Model",
      "type": "object",
      "propertyCount": 6,
      "required": []
    },
    {
      "name": "ModelList",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "Routine",
      "type": "object",
      "propertyCount": 6,
      "required": []
    },
    {
      "name": "RoutineList",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "ProjectList",
      "type": "object",
      "propertyCount": 4,
      "required": []
    },
    {
      "name": "ErrorProto",
      "type": "object",
      "propertyCount": 3,
      "required": []
    }
  ],
  "operations": [
    {
      "method": "GET",
      "path": "/projects",
      "operationId": "listProjects",
      "summary": "Google BigQuery List projects",
      "tags": [
        "Projects"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/datasets",
      "operationId": "listDatasets",
      "summary": "Google BigQuery List datasets",
      "tags": [
        "Datasets"
      ]
    },
    {
      "method": "POST",
      "path": "/projects/{projectId}/datasets",
      "operationId": "insertDataset",
      "summary": "Google BigQuery Create a dataset",
      "tags": [
        "Datasets"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/datasets/{datasetId}",
      "operationId": "getDataset",
      "summary": "Google BigQuery Get dataset",
      "tags": [
        "Datasets"
      ]
    },
    {
      "method": "PUT",
      "path": "/projects/{projectId}/datasets/{datasetId}",
      "operationId": "updateDataset",
      "summary": "Google BigQuery Update dataset",
      "tags": [
        "Datasets"
      ]
    },
    {
      "method": "DELETE",
      "path": "/projects/{projectId}/datasets/{datasetId}",
      "operationId": "deleteDataset",
      "summary": "Google BigQuery Delete dataset",
      "tags": [
        "Datasets"
      ]
    },
    {
      "method": "PATCH",
      "path": "/projects/{projectId}/datasets/{datasetId}",
      "operationId": "patchDataset",
      "summary": "Google BigQuery Partially update dataset",
      "tags": [
        "Datasets"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/datasets/{datasetId}/tables",
      "operationId": "listTables",
      "summary": "Google BigQuery List tables",
      "tags": [
        "Tables"
      ]
    },
    {
      "method": "POST",
      "path": "/projects/{projectId}/datasets/{datasetId}/tables",
      "operationId": "insertTable",
      "summary": "Google BigQuery Create a table",
      "tags": [
        "Tables"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/datasets/{datasetId}/tables/{tableId}",
      "operationId": "getTable",
      "summary": "Google BigQuery Get table",
      "tags": [
        "Tables"
      ]
    },
    {
      "method": "DELETE",
      "path": "/projects/{projectId}/datasets/{datasetId}/tables/{tableId}",
      "operationId": "deleteTable",
      "summary": "Google BigQuery Delete table",
      "tags": [
        "Tables"
      ]
    },
    {
      "method": "PATCH",
      "path": "/projects/{projectId}/datasets/{datasetId}/tables/{tableId}",
      "operationId": "patchTable",
      "summary": "Google BigQuery Partially update table",
      "tags": [
        "Tables"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data",
      "operationId": "listTabledata",
      "summary": "Google BigQuery List table rows",
      "tags": [
        "Tabledata"
      ]
    },
    {
      "method": "POST",
      "path": "/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll",
      "operationId": "insertAllTabledata",
      "summary": "Google BigQuery Insert rows",
      "tags": [
        "Tabledata"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/jobs",
      "operationId": "listJobs",
      "summary": "Google BigQuery List jobs",
      "tags": [
        "Jobs"
      ]
    },
    {
      "method": "POST",
      "path": "/projects/{projectId}/jobs",
      "operationId": "insertJob",
      "summary": "Google BigQuery Submit a job",
      "tags": [
        "Jobs"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/jobs/{jobId}",
      "operationId": "getJob",
      "summary": "Google BigQuery Get job",
      "tags": [
        "Jobs"
      ]
    },
    {
      "method": "DELETE",
      "path": "/projects/{projectId}/jobs/{jobId}",
      "operationId": "deleteJob",
      "summary": "Google BigQuery Delete job",
      "tags": [
        "Jobs"
      ]
    },
    {
      "method": "POST",
      "path": "/projects/{projectId}/jobs/{jobId}/cancel",
      "operationId": "cancelJob",
      "summary": "Google BigQuery Cancel job",
      "tags": [
        "Jobs"
      ]
    },
    {
      "method": "POST",
      "path": "/projects/{projectId}/queries",
      "operationId": "queryJobs",
      "summary": "Google BigQuery Execute query",
      "tags": [
        "Jobs"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/queries/{jobId}",
      "operationId": "getQueryResults",
      "summary": "Google BigQuery Get query results",
      "tags": [
        "Jobs"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/datasets/{datasetId}/models",
      "operationId": "listModels",
      "summary": "Google BigQuery List models",
      "tags": [
        "Models"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/datasets/{datasetId}/models/{modelId}",
      "operationId": "getModel",
      "summary": "Google BigQuery Get model",
      "tags": [
        "Models"
      ]
    },
    {
      "method": "DELETE",
      "path": "/projects/{projectId}/datasets/{datasetId}/models/{modelId}",
      "operationId": "deleteModel",
      "summary": "Google BigQuery Delete model",
      "tags": [
        "Models"
      ]
    },
    {
      "method": "PATCH",
      "path": "/projects/{projectId}/datasets/{datasetId}/models/{modelId}",
      "operationId": "patchModel",
      "summary": "Google BigQuery Update model",
      "tags": [
        "Models"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/datasets/{datasetId}/routines",
      "operationId": "listRoutines",
      "summary": "Google BigQuery List routines",
      "tags": [
        "Routines"
      ]
    },
    {
      "method": "POST",
      "path": "/projects/{projectId}/datasets/{datasetId}/routines",
      "operationId": "insertRoutine",
      "summary": "Google BigQuery Create a routine",
      "tags": [
        "Routines"
      ]
    },
    {
      "method": "GET",
      "path": "/projects/{projectId}/datasets/{datasetId}/routines/{routineId}",
      "operationId": "getRoutine",
      "summary": "Google BigQuery Get routine",
      "tags": [
        "Routines"
      ]
    },
    {
      "method": "PUT",
      "path": "/projects/{projectId}/datasets/{datasetId}/routines/{routineId}",
      "operationId": "updateRoutine",
      "summary": "Google BigQuery Update routine",
      "tags": [
        "Routines"
      ]
    },
    {
      "method": "DELETE",
      "path": "/projects/{projectId}/datasets/{datasetId}/routines/{routineId}",
      "operationId": "deleteRoutine",
      "summary": "Google BigQuery Delete routine",
      "tags": [
        "Routines"
      ]
    }
  ]
}

Work with this as data

Every JSON Structure here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for json structure

4 MCP tools reach this
  • find_json_structuresBrowse and filter every JSON Structure in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Structure
curl "https://apis.io/api/v1/json-structures/google-bigquery-structure"
All json structure
curl "https://apis.io/api/v1/json-structures?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.