Console
    Start free

    BigQuery API

    A data platform for customers to create, manage, share and query data.

    Service: bigquery.googleapis.com

    To call this service, we recommend that you use the Google-provided client libraries . If your application needs to use your own libraries to call this service, use the following information when you make the API requests.

    Discovery document

    A Discovery Document is a machine-readable specification for describing and consuming REST APIs. It is used to build client libraries, IDE plugins, and other tools that interact with Google APIs. One service may provide multiple discovery documents. This service provides the following discovery document:

    Service endpoint

    A service endpoint is a base URL that specifies the network address of an API service. One service might have multiple service endpoints. This service has the following service endpoint and all URIs below are relative to this service endpoint:

    • https://bigquery.googleapis.com

    REST Resource: v2.datasets

    Methods
    delete DELETE /bigquery/v2/projects/{projectId}/datasets/{datasetId}
    Deletes the dataset specified by the datasetId value.
    get GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}
    Returns the dataset specified by datasetID.
    insert POST /bigquery/v2/projects/{projectId}/datasets
    Creates a new empty dataset.
    list GET /bigquery/v2/projects/{projectId}/datasets
    Lists all datasets in the specified project to which the user has been granted the READER dataset role.
    patch PATCH /bigquery/v2/projects/{projectId}/datasets/{datasetId}
    Updates information in an existing dataset.
    undelete POST /bigquery/v2/projects/{projectId}/datasets/{datasetId}:undelete
    Undeletes a dataset which is within time travel window based on datasetId.
    update PUT /bigquery/v2/projects/{projectId}/datasets/{datasetId}
    Updates information in an existing dataset.

    REST Resource: v2.jobs

    Methods
    cancel POST /bigquery/v2/projects/{projectId}/jobs/{jobId}/cancel
    Requests that a job be cancelled.
    delete DELETE /bigquery/v2/projects/{projectId}/jobs/{jobId}/delete
    Requests the deletion of the metadata of a job.
    get GET /bigquery/v2/projects/{projectId}/jobs/{jobId}
    Returns information about a specific job.
    getQueryResults GET /bigquery/v2/projects/{projectId}/queries/{jobId}
    RPC to get the results of a query job.
    insert POST /bigquery/v2/projects/{projectId}/jobs
    POST /upload/bigquery/v2/projects/{projectId}/jobs
    Starts a new asynchronous job.
    list GET /bigquery/v2/projects/{projectId}/jobs
    Lists all jobs that you started in the specified project.
    query POST /bigquery/v2/projects/{projectId}/queries
    Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout.

    REST Resource: v2.models

    Methods
    delete DELETE /bigquery/v2/projects/{projectId}/datasets/{datasetId}/models/{modelId}
    Deletes the model specified by modelId from the dataset.
    get GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/models/{modelId}
    Gets the specified model resource by model ID.
    list GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/models
    Lists all models in the specified dataset.
    patch PATCH /bigquery/v2/projects/{projectId}/datasets/{datasetId}/models/{modelId}
    Patch specific fields in the specified model.

    REST Resource: v2.projects

    Methods
    getServiceAccount GET /bigquery/v2/projects/{projectId}/serviceAccount
    RPC to get the service account for a project used for interactions with Google Cloud KMS
    list GET /bigquery/v2/projects
    RPC to list projects to which the user has been granted any project role.

    REST Resource: v2.routines

    Methods
    delete DELETE /bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines/{routineId}
    Deletes the routine specified by routineId from the dataset.
    get GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines/{routineId}
    Gets the specified routine resource by routine ID.
    getIamPolicy POST /bigquery/v2/{resource=projects/*/datasets/*/routines/*}:getIamPolicy
    Gets the access control policy for a resource.
    insert POST /bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines
    Creates a new routine in the dataset.
    list GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines
    Lists all routines in the specified dataset.
    setIamPolicy POST /bigquery/v2/{resource=projects/*/datasets/*/routines/*}:setIamPolicy
    Sets the access control policy on the specified resource.
    testIamPermissions POST /bigquery/v2/{resource=projects/*/datasets/*/routines/*}:testIamPermissions
    Returns permissions that a caller has on the specified resource.
    update PUT /bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines/{routineId}
    Updates information in an existing routine.

    REST Resource: v2.rowAccessPolicies

    Methods
    getIamPolicy POST /bigquery/v2/{resource=projects/*/datasets/*/tables/*/rowAccessPolicies/*}:getIamPolicy
    Gets the access control policy for a resource.
    list GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/rowAccessPolicies
    Lists all row access policies on the specified table.
    testIamPermissions POST /bigquery/v2/{resource=projects/*/datasets/*/tables/*/rowAccessPolicies/*}:testIamPermissions
    Returns permissions that a caller has on the specified resource.

    REST Resource: v2.tabledata

    Methods
    insertAll POST /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll
    Streams data into BigQuery one record at a time without needing to run a load job.
    list GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data
    List the content of a table in rows.

    REST Resource: v2.tables

    Methods
    delete DELETE /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}
    Deletes the table specified by tableId from the dataset.
    get GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}
    Gets the specified table resource by table ID.
    getIamPolicy POST /bigquery/v2/{resource=projects/*/datasets/*/tables/*}:getIamPolicy
    Gets the access control policy for a resource.
    insert POST /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables
    Creates a new, empty table in the dataset.
    list GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables
    Lists all tables in the specified dataset.
    patch PATCH /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}
    Updates information in an existing table.
    setIamPolicy POST /bigquery/v2/{resource=projects/*/datasets/*/tables/*}:setIamPolicy
    Sets the access control policy on the specified resource.
    testIamPermissions POST /bigquery/v2/{resource=projects/*/datasets/*/tables/*}:testIamPermissions
    Returns permissions that a caller has on the specified resource.
    update PUT /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}
    Updates information in an existing table.
    Design a Mobile Site
    View Site in Mobile | Classic
    Share by: