Google BigQuery · Capability

Google BigQuery API

The BigQuery API provides programmatic access to Google BigQuery for creating, managing, and querying datasets, tables, jobs, models, and routines. It enables developers to run SQL queries over petabytes of data, load and export data, manage access control, and orchestrate analytics workloads using serverless infrastructure.

Run with Naftiko GoogleBigqueryAPI

What You Can Do

GET
Listprojects — Google BigQuery List projects
/projects
GET
Listdatasets — Google BigQuery List datasets
/projects/{projectId}/datasets
POST
Insertdataset — Google BigQuery Create a dataset
/projects/{projectId}/datasets
GET
Getdataset — Google BigQuery Get dataset
/projects/{projectId}/datasets/{datasetId}
PATCH
Patchdataset — Google BigQuery Partially update dataset
/projects/{projectId}/datasets/{datasetId}
PUT
Updatedataset — Google BigQuery Update dataset
/projects/{projectId}/datasets/{datasetId}
DELETE
Deletedataset — Google BigQuery Delete dataset
/projects/{projectId}/datasets/{datasetId}
GET
Listtables — Google BigQuery List tables
/projects/{projectId}/datasets/{datasetId}/tables
POST
Inserttable — Google BigQuery Create a table
/projects/{projectId}/datasets/{datasetId}/tables
GET
Gettable — Google BigQuery Get table
/projects/{projectId}/datasets/{datasetId}/tables/{tableId}
PATCH
Patchtable — Google BigQuery Partially update table
/projects/{projectId}/datasets/{datasetId}/tables/{tableId}
DELETE
Deletetable — Google BigQuery Delete table
/projects/{projectId}/datasets/{datasetId}/tables/{tableId}
GET
Listtabledata — Google BigQuery List table rows
/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data
POST
Insertalltabledata — Google BigQuery Insert rows
/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll
GET
Listjobs — Google BigQuery List jobs
/projects/{projectId}/jobs
POST
Insertjob — Google BigQuery Submit a job
/projects/{projectId}/jobs
GET
Getjob — Google BigQuery Get job
/projects/{projectId}/jobs/{jobId}
DELETE
Deletejob — Google BigQuery Delete job
/projects/{projectId}/jobs/{jobId}
POST
Canceljob — Google BigQuery Cancel job
/projects/{projectId}/jobs/{jobId}/cancel
POST
Queryjobs — Google BigQuery Execute query
/projects/{projectId}/queries
GET
Getqueryresults — Google BigQuery Get query results
/projects/{projectId}/queries/{jobId}
GET
Listmodels — Google BigQuery List models
/projects/{projectId}/datasets/{datasetId}/models
GET
Getmodel — Google BigQuery Get model
/projects/{projectId}/datasets/{datasetId}/models/{modelId}
PATCH
Patchmodel — Google BigQuery Update model
/projects/{projectId}/datasets/{datasetId}/models/{modelId}
DELETE
Deletemodel — Google BigQuery Delete model
/projects/{projectId}/datasets/{datasetId}/models/{modelId}
GET
Listroutines — Google BigQuery List routines
/projects/{projectId}/datasets/{datasetId}/routines
POST
Insertroutine — Google BigQuery Create a routine
/projects/{projectId}/datasets/{datasetId}/routines
GET
Getroutine — Google BigQuery Get routine
/projects/{projectId}/datasets/{datasetId}/routines/{routineId}
PUT
Updateroutine — Google BigQuery Update routine
/projects/{projectId}/datasets/{datasetId}/routines/{routineId}
DELETE
Deleteroutine — Google BigQuery Delete routine
/projects/{projectId}/datasets/{datasetId}/routines/{routineId}

MCP Tools

listprojects

Google BigQuery List projects

read-only idempotent
listdatasets

Google BigQuery List datasets

read-only idempotent
insertdataset

Google BigQuery Create a dataset

getdataset

Google BigQuery Get dataset

read-only idempotent
patchdataset

Google BigQuery Partially update dataset

updatedataset

Google BigQuery Update dataset

idempotent
deletedataset

Google BigQuery Delete dataset

idempotent
listtables

Google BigQuery List tables

read-only idempotent
inserttable

Google BigQuery Create a table

gettable

Google BigQuery Get table

read-only idempotent
patchtable

Google BigQuery Partially update table

deletetable

Google BigQuery Delete table

idempotent
listtabledata

Google BigQuery List table rows

read-only idempotent
insertalltabledata

Google BigQuery Insert rows

listjobs

Google BigQuery List jobs

read-only idempotent
insertjob

Google BigQuery Submit a job

getjob

Google BigQuery Get job

read-only idempotent
deletejob

Google BigQuery Delete job

idempotent
canceljob

Google BigQuery Cancel job

queryjobs

Google BigQuery Execute query

getqueryresults

Google BigQuery Get query results

read-only idempotent
listmodels

Google BigQuery List models

read-only idempotent
getmodel

Google BigQuery Get model

read-only idempotent
patchmodel

Google BigQuery Update model

deletemodel

Google BigQuery Delete model

idempotent
listroutines

Google BigQuery List routines

read-only idempotent
insertroutine

Google BigQuery Create a routine

getroutine

Google BigQuery Get routine

read-only idempotent
updateroutine

Google BigQuery Update routine

idempotent
deleteroutine

Google BigQuery Delete routine

idempotent

Capability Spec

google-bigquery-capability.yaml Raw ↑
naftiko: 1.0.0-alpha2
info:
  label: Google BigQuery API
  description: The BigQuery API provides programmatic access to Google BigQuery for creating, managing, and querying datasets,
    tables, jobs, models, and routines. It enables developers to run SQL queries over petabytes of data, load and export data,
    manage access control, and orchestrate analytics workloads using serverless infrastructure.
  tags:
  - Google
  - Bigquery
  - API
  created: '2026-05-06'
  modified: '2026-05-06'
capability:
  consumes:
  - type: http
    namespace: google-bigquery
    baseUri: https://bigquery.googleapis.com/bigquery/v2
    description: Google BigQuery API HTTP API.
    authentication:
      type: bearer
      token: '{{GOOGLE_BIGQUERY_TOKEN}}'
    resources:
    - name: projects
      path: /projects
      operations:
      - name: listprojects
        method: GET
        description: Google BigQuery List projects
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-datasets
      path: /projects/{projectId}/datasets
      operations:
      - name: listdatasets
        method: GET
        description: Google BigQuery List datasets
        inputParameters:
        - name: all
          in: query
          type: boolean
          description: Whether to list all datasets, including hidden ones
        - name: filter
          in: query
          type: string
          description: Filter expression for filtering datasets by label
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: insertdataset
        method: POST
        description: Google BigQuery Create a dataset
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-datasets-datasetid
      path: /projects/{projectId}/datasets/{datasetId}
      operations:
      - name: getdataset
        method: GET
        description: Google BigQuery Get dataset
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: patchdataset
        method: PATCH
        description: Google BigQuery Partially update dataset
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: updatedataset
        method: PUT
        description: Google BigQuery Update dataset
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: deletedataset
        method: DELETE
        description: Google BigQuery Delete dataset
        inputParameters:
        - name: deleteContents
          in: query
          type: boolean
          description: If true, delete all the tables in the dataset
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-datasets-datasetid-tables
      path: /projects/{projectId}/datasets/{datasetId}/tables
      operations:
      - name: listtables
        method: GET
        description: Google BigQuery List tables
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: inserttable
        method: POST
        description: Google BigQuery Create a table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-datasets-datasetid-tables-tab
      path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}
      operations:
      - name: gettable
        method: GET
        description: Google BigQuery Get table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: patchtable
        method: PATCH
        description: Google BigQuery Partially update table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: deletetable
        method: DELETE
        description: Google BigQuery Delete table
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-datasets-datasetid-tables-tab
      path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data
      operations:
      - name: listtabledata
        method: GET
        description: Google BigQuery List table rows
        inputParameters:
        - name: startIndex
          in: query
          type: integer
          description: Zero-based index of the starting row to read
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-datasets-datasetid-tables-tab
      path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll
      operations:
      - name: insertalltabledata
        method: POST
        description: Google BigQuery Insert rows
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-jobs
      path: /projects/{projectId}/jobs
      operations:
      - name: listjobs
        method: GET
        description: Google BigQuery List jobs
        inputParameters:
        - name: projection
          in: query
          type: string
          description: Restricts information returned to a set of selected fields
        - name: stateFilter
          in: query
          type: array
          description: Filter for job state
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: insertjob
        method: POST
        description: Google BigQuery Submit a job
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-jobs-jobid
      path: /projects/{projectId}/jobs/{jobId}
      operations:
      - name: getjob
        method: GET
        description: Google BigQuery Get job
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: deletejob
        method: DELETE
        description: Google BigQuery Delete job
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-jobs-jobid-cancel
      path: /projects/{projectId}/jobs/{jobId}/cancel
      operations:
      - name: canceljob
        method: POST
        description: Google BigQuery Cancel job
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-queries
      path: /projects/{projectId}/queries
      operations:
      - name: queryjobs
        method: POST
        description: Google BigQuery Execute query
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-queries-jobid
      path: /projects/{projectId}/queries/{jobId}
      operations:
      - name: getqueryresults
        method: GET
        description: Google BigQuery Get query results
        inputParameters:
        - name: startIndex
          in: query
          type: integer
          description: Zero-based index of the starting row
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-datasets-datasetid-models
      path: /projects/{projectId}/datasets/{datasetId}/models
      operations:
      - name: listmodels
        method: GET
        description: Google BigQuery List models
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-datasets-datasetid-models-mod
      path: /projects/{projectId}/datasets/{datasetId}/models/{modelId}
      operations:
      - name: getmodel
        method: GET
        description: Google BigQuery Get model
        inputParameters:
        - name: modelId
          in: path
          type: string
          required: true
          description: The ID of the model
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: patchmodel
        method: PATCH
        description: Google BigQuery Update model
        inputParameters:
        - name: modelId
          in: path
          type: string
          required: true
          description: The ID of the model
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: deletemodel
        method: DELETE
        description: Google BigQuery Delete model
        inputParameters:
        - name: modelId
          in: path
          type: string
          required: true
          description: The ID of the model
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-datasets-datasetid-routines
      path: /projects/{projectId}/datasets/{datasetId}/routines
      operations:
      - name: listroutines
        method: GET
        description: Google BigQuery List routines
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: insertroutine
        method: POST
        description: Google BigQuery Create a routine
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: projects-projectid-datasets-datasetid-routines-r
      path: /projects/{projectId}/datasets/{datasetId}/routines/{routineId}
      operations:
      - name: getroutine
        method: GET
        description: Google BigQuery Get routine
        inputParameters:
        - name: routineId
          in: path
          type: string
          required: true
          description: The ID of the routine
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: updateroutine
        method: PUT
        description: Google BigQuery Update routine
        inputParameters:
        - name: routineId
          in: path
          type: string
          required: true
          description: The ID of the routine
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: deleteroutine
        method: DELETE
        description: Google BigQuery Delete routine
        inputParameters:
        - name: routineId
          in: path
          type: string
          required: true
          description: The ID of the routine
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
  exposes:
  - type: rest
    port: 8080
    namespace: google-bigquery-rest
    description: REST adapter for Google BigQuery API.
    resources:
    - path: /projects
      name: listprojects
      operations:
      - method: GET
        name: listprojects
        description: Google BigQuery List projects
        call: google-bigquery.listprojects
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets
      name: listdatasets
      operations:
      - method: GET
        name: listdatasets
        description: Google BigQuery List datasets
        call: google-bigquery.listdatasets
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets
      name: insertdataset
      operations:
      - method: POST
        name: insertdataset
        description: Google BigQuery Create a dataset
        call: google-bigquery.insertdataset
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}
      name: getdataset
      operations:
      - method: GET
        name: getdataset
        description: Google BigQuery Get dataset
        call: google-bigquery.getdataset
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}
      name: patchdataset
      operations:
      - method: PATCH
        name: patchdataset
        description: Google BigQuery Partially update dataset
        call: google-bigquery.patchdataset
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}
      name: updatedataset
      operations:
      - method: PUT
        name: updatedataset
        description: Google BigQuery Update dataset
        call: google-bigquery.updatedataset
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}
      name: deletedataset
      operations:
      - method: DELETE
        name: deletedataset
        description: Google BigQuery Delete dataset
        call: google-bigquery.deletedataset
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/tables
      name: listtables
      operations:
      - method: GET
        name: listtables
        description: Google BigQuery List tables
        call: google-bigquery.listtables
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/tables
      name: inserttable
      operations:
      - method: POST
        name: inserttable
        description: Google BigQuery Create a table
        call: google-bigquery.inserttable
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}
      name: gettable
      operations:
      - method: GET
        name: gettable
        description: Google BigQuery Get table
        call: google-bigquery.gettable
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}
      name: patchtable
      operations:
      - method: PATCH
        name: patchtable
        description: Google BigQuery Partially update table
        call: google-bigquery.patchtable
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}
      name: deletetable
      operations:
      - method: DELETE
        name: deletetable
        description: Google BigQuery Delete table
        call: google-bigquery.deletetable
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data
      name: listtabledata
      operations:
      - method: GET
        name: listtabledata
        description: Google BigQuery List table rows
        call: google-bigquery.listtabledata
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll
      name: insertalltabledata
      operations:
      - method: POST
        name: insertalltabledata
        description: Google BigQuery Insert rows
        call: google-bigquery.insertalltabledata
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/jobs
      name: listjobs
      operations:
      - method: GET
        name: listjobs
        description: Google BigQuery List jobs
        call: google-bigquery.listjobs
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/jobs
      name: insertjob
      operations:
      - method: POST
        name: insertjob
        description: Google BigQuery Submit a job
        call: google-bigquery.insertjob
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/jobs/{jobId}
      name: getjob
      operations:
      - method: GET
        name: getjob
        description: Google BigQuery Get job
        call: google-bigquery.getjob
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/jobs/{jobId}
      name: deletejob
      operations:
      - method: DELETE
        name: deletejob
        description: Google BigQuery Delete job
        call: google-bigquery.deletejob
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/jobs/{jobId}/cancel
      name: canceljob
      operations:
      - method: POST
        name: canceljob
        description: Google BigQuery Cancel job
        call: google-bigquery.canceljob
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/queries
      name: queryjobs
      operations:
      - method: POST
        name: queryjobs
        description: Google BigQuery Execute query
        call: google-bigquery.queryjobs
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/queries/{jobId}
      name: getqueryresults
      operations:
      - method: GET
        name: getqueryresults
        description: Google BigQuery Get query results
        call: google-bigquery.getqueryresults
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/models
      name: listmodels
      operations:
      - method: GET
        name: listmodels
        description: Google BigQuery List models
        call: google-bigquery.listmodels
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/models/{modelId}
      name: getmodel
      operations:
      - method: GET
        name: getmodel
        description: Google BigQuery Get model
        call: google-bigquery.getmodel
        with:
          modelId: rest.modelId
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/models/{modelId}
      name: patchmodel
      operations:
      - method: PATCH
        name: patchmodel
        description: Google BigQuery Update model
        call: google-bigquery.patchmodel
        with:
          modelId: rest.modelId
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/models/{modelId}
      name: deletemodel
      operations:
      - method: DELETE
        name: deletemodel
        description: Google BigQuery Delete model
        call: google-bigquery.deletemodel
        with:
          modelId: rest.modelId
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/routines
      name: listroutines
      operations:
      - method: GET
        name: listroutines
        description: Google BigQuery List routines
        call: google-bigquery.listroutines
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/routines
      name: insertroutine
      operations:
      - method: POST
        name: insertroutine
        description: Google BigQuery Create a routine
        call: google-bigquery.insertroutine
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/routines/{routineId}
      name: getroutine
      operations:
      - method: GET
        name: getroutine
        description: Google BigQuery Get routine
        call: google-bigquery.getroutine
        with:
          routineId: rest.routineId
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/routines/{routineId}
      name: updateroutine
      operations:
      - method: PUT
        name: updateroutine
        description: Google BigQuery Update routine
        call: google-bigquery.updateroutine
        with:
          routineId: rest.routineId
        outputParameters:
        - type: object
          mapping: $.
    - path: /projects/{projectId}/datasets/{datasetId}/routines/{routineId}
      name: deleteroutine
      operations:
      - method: DELETE
        name: deleteroutine
        description: Google BigQuery Delete routine
        call: google-bigquery.deleteroutine
        with:
          routineId: rest.routineId
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    port: 9090
    namespace: google-bigquery-mcp
    transport: http
    description: MCP adapter for Google BigQuery API for AI agent use.
    tools:
    - name: listprojects
      description: Google BigQuery List projects
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.listprojects
      outputParameters:
      - type: object
        mapping: $.
    - name: listdatasets
      description: Google BigQuery List datasets
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.listdatasets
      with:
        all: tools.all
        filter: tools.filter
      inputParameters:
      - name: all
        type: boolean
        description: Whether to list all datasets, including hidden ones
      - name: filter
        type: string
        description: Filter expression for filtering datasets by label
      outputParameters:
      - type: object
        mapping: $.
    - name: insertdataset
      description: Google BigQuery Create a dataset
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: google-bigquery.insertdataset
      outputParameters:
      - type: object
        mapping: $.
    - name: getdataset
      description: Google BigQuery Get dataset
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.getdataset
      outputParameters:
      - type: object
        mapping: $.
    - name: patchdataset
      description: Google BigQuery Partially update dataset
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: google-bigquery.patchdataset
      outputParameters:
      - type: object
        mapping: $.
    - name: updatedataset
      description: Google BigQuery Update dataset
      hints:
        readOnly: false
        destructive: false
        idempotent: true
      call: google-bigquery.updatedataset
      outputParameters:
      - type: object
        mapping: $.
    - name: deletedataset
      description: Google BigQuery Delete dataset
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: google-bigquery.deletedataset
      with:
        deleteContents: tools.deleteContents
      inputParameters:
      - name: deleteContents
        type: boolean
        description: If true, delete all the tables in the dataset
      outputParameters:
      - type: object
        mapping: $.
    - name: listtables
      description: Google BigQuery List tables
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.listtables
      outputParameters:
      - type: object
        mapping: $.
    - name: inserttable
      description: Google BigQuery Create a table
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: google-bigquery.inserttable
      outputParameters:
      - type: object
        mapping: $.
    - name: gettable
      description: Google BigQuery Get table
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.gettable
      outputParameters:
      - type: object
        mapping: $.
    - name: patchtable
      description: Google BigQuery Partially update table
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: google-bigquery.patchtable
      outputParameters:
      - type: object
        mapping: $.
    - name: deletetable
      description: Google BigQuery Delete table
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: google-bigquery.deletetable
      outputParameters:
      - type: object
        mapping: $.
    - name: listtabledata
      description: Google BigQuery List table rows
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.listtabledata
      with:
        startIndex: tools.startIndex
      inputParameters:
      - name: startIndex
        type: integer
        description: Zero-based index of the starting row to read
      outputParameters:
      - type: object
        mapping: $.
    - name: insertalltabledata
      description: Google BigQuery Insert rows
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: google-bigquery.insertalltabledata
      outputParameters:
      - type: object
        mapping: $.
    - name: listjobs
      description: Google BigQuery List jobs
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.listjobs
      with:
        projection: tools.projection
        stateFilter: tools.stateFilter
      inputParameters:
      - name: projection
        type: string
        description: Restricts information returned to a set of selected fields
      - name: stateFilter
        type: array
        description: Filter for job state
      outputParameters:
      - type: object
        mapping: $.
    - name: insertjob
      description: Google BigQuery Submit a job
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: google-bigquery.insertjob
      outputParameters:
      - type: object
        mapping: $.
    - name: getjob
      description: Google BigQuery Get job
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.getjob
      outputParameters:
      - type: object
        mapping: $.
    - name: deletejob
      description: Google BigQuery Delete job
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: google-bigquery.deletejob
      outputParameters:
      - type: object
        mapping: $.
    - name: canceljob
      description: Google BigQuery Cancel job
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: google-bigquery.canceljob
      outputParameters:
      - type: object
        mapping: $.
    - name: queryjobs
      description: Google BigQuery Execute query
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: google-bigquery.queryjobs
      outputParameters:
      - type: object
        mapping: $.
    - name: getqueryresults
      description: Google BigQuery Get query results
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.getqueryresults
      with:
        startIndex: tools.startIndex
      inputParameters:
      - name: startIndex
        type: integer
        description: Zero-based index of the starting row
      outputParameters:
      - type: object
        mapping: $.
    - name: listmodels
      description: Google BigQuery List models
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.listmodels
      outputParameters:
      - type: object
        mapping: $.
    - name: getmodel
      description: Google BigQuery Get model
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.getmodel
      with:
        modelId: tools.modelId
      inputParameters:
      - name: modelId
        type: string
        description: The ID of the model
        required: true
      outputParameters:
      - type: object
        mapping: $.
    - name: patchmodel
      description: Google BigQuery Update model
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: google-bigquery.patchmodel
      with:
        modelId: tools.modelId
      inputParameters:
      - name: modelId
        type: string
        description: The ID of the model
        required: true
      outputParameters:
      - type: object
        mapping: $.
    - name: deletemodel
      description: Google BigQuery Delete model
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: google-bigquery.deletemodel
      with:
        modelId: tools.modelId
      inputParameters:
      - name: modelId
        type: string
        description: The ID of the model
        required: true
      outputParameters:
      - type: object
        mapping: $.
    - name: listroutines
      description: Google BigQuery List routines
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.listroutines
      outputParameters:
      - type: object
        mapping: $.
    - name: insertroutine
      description: Google BigQuery Create a routine
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: google-bigquery.insertroutine
      outputParameters:
      - type: object
        mapping: $.
    - name: getroutine
      description: Google BigQuery Get routine
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: google-bigquery.getroutine
      with:
        routineId: tools.routineId
      inputParameters:
      - name: routineId
        type: string
        description: The ID of the routine
        required: true
      outputParameters:
      - type: object
        mapping: $.
    - name: updateroutine
      description: Google BigQuery Update routine
      hints:
        readOnly: false
        destructive: false
        idempotent: true
      call: google-bigquery.updateroutine
      with:
        routineId: tools.routineId
      inputParameters:
      - name: routineId
        type: string
        description: The ID of the routine
        required: true
      outputParameters:
      - type: object
        mapping: $.
    - name: deleteroutine
      description: Google BigQuery Delete routine
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: google-bigquery.deleteroutine
      with:
        routineId: tools.routineId
      inputParameters:
      - name: routineId
        type: string
        description: The ID of the routine
        required: true
      outputParameters:
      - type: object
        mapping: $.
binds:
- namespace: env
  keys:
    GOOGLE_BIGQUERY_TOKEN: GOOGLE_BIGQUERY_TOKEN