BigQuery API (bigquery:v2)

▼ ▲ bigquery.datasets.undelete

Description : Undeletes a dataset which is within time travel window based on datasetId. If a time is specified, the dataset version deleted at that time is undeleted, else the last live version is undeleted.

Flat Path : projects/{projectsId}/datasets/{datasetsId}:undelete

HTTP Method : POST

Parameter Order :

• projectId
• datasetId

Parameters :

datasetId

Description : Required. Dataset ID of dataset being deleted

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the dataset to be undeleted

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{+projectId}/datasets/{+datasetId}:undelete

Scopes :

• https://www.googleapis.com/auth/bigquery
• https://www.googleapis.com/auth/cloud-platform

▼ ▲ bigquery.datasets.delete

Parameters :

datasetId

Description : Required. Dataset ID of dataset being deleted

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the dataset being deleted

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets/{datasetId}  ⟶  projects/{+projectId}/datasets/{+datasetId}

▼ ▲ bigquery.datasets.get

Parameters :

datasetId

Description : Required. Dataset ID of the requested dataset

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

datasetView

Description : Optional. Specifies the view that determines which dataset information is returned. By default, metadata and ACL information are returned.

Enum :

• DATASET_VIEW_UNSPECIFIED
• METADATA
• ACL
• FULL

Enum Descriptions :

• The default value. Default to the FULL view.
• Includes metadata information for the dataset, such as location, etag, lastModifiedTime, etc.
• Includes ACL information for the dataset, which defines dataset access for one or more entities.
• Includes both dataset metadata and ACL information.

Location : query

Type : string

projectId

Description : Required. Project ID of the requested dataset

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets/{datasetId}  ⟶  projects/{+projectId}/datasets/{+datasetId}

▼ ▲ bigquery.datasets.insert

Parameters :

projectId

Description : Required. Project ID of the new dataset

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets  ⟶  projects/{+projectId}/datasets

▼ ▲ bigquery.datasets.list

Parameters :

projectId

Description : Required. Project ID of the datasets to be listed

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets  ⟶  projects/{+projectId}/datasets

▼ ▲ bigquery.datasets.patch

Parameters :

datasetId

Description : Required. Dataset ID of the dataset being updated

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the dataset being updated

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets/{datasetId}  ⟶  projects/{+projectId}/datasets/{+datasetId}

▼ ▲ bigquery.datasets.update

Parameters :

datasetId

Description : Required. Dataset ID of the dataset being updated

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the dataset being updated

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets/{datasetId}  ⟶  projects/{+projectId}/datasets/{+datasetId}

▼ ▲ bigquery.jobs.cancel

Parameters :

jobId

Description : Required. Job ID of the job to cancel

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the job to cancel

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/jobs/{jobId}/cancel  ⟶  projects/{+projectId}/jobs/{+jobId}/cancel

▼ ▲ bigquery.jobs.get

Parameters :

jobId

Description : Required. Job ID of the requested job.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the requested job.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/jobs/{jobId}  ⟶  projects/{+projectId}/jobs/{+jobId}

▼ ▲ bigquery.jobs.getQueryResults

Parameters :

formatOptions.useInt64Timestamp

Description : Optional. Output timestamp as usec int64. Default is false.

Location : query

Type : boolean

jobId

Description : Required. Job ID of the query job.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the query job.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/queries/{jobId}  ⟶  projects/{+projectId}/queries/{+jobId}

▼ ▲ bigquery.jobs.insert

Parameters :

projectId

Description : Project ID of project that will be billed for the job.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Mediaupload :

Protocols :

Resumable : /resumable/upload/bigquery/v2/projects/{projectId}/jobs  ⟶  /resumable/upload/bigquery/v2/projects/{+projectId}/jobs

Simple : /upload/bigquery/v2/projects/{projectId}/jobs  ⟶  /upload/bigquery/v2/projects/{+projectId}/jobs

Path : projects/{projectId}/jobs  ⟶  projects/{+projectId}/jobs

▼ ▲ bigquery.jobs.list

Parameters :

projectId

Description : Project ID of the jobs to list.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/jobs  ⟶  projects/{+projectId}/jobs

▼ ▲ bigquery.jobs.query

Parameters :

projectId

Description : Required. Project ID of the query request.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/queries  ⟶  projects/{+projectId}/queries

▼ ▲ bigquery.projects.getServiceAccount

Parameters :

projectId

Description : Required. ID of the project.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/serviceAccount  ⟶  projects/{+projectId}/serviceAccount

▼ ▲ bigquery.tabledata.insertAll

Parameters :

datasetId

Description : Required. Dataset ID of the destination.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the destination.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

tableId

Description : Required. Table ID of the destination.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll  ⟶  projects/{+projectId}/datasets/{+datasetId}/tables/{+tableId}/insertAll

▼ ▲ bigquery.tabledata.list

Parameters :

formatOptions.useInt64Timestamp

Description : Optional. Output timestamp as usec int64. Default is false.

Location : query

Type : boolean

datasetId

Description : Required. Dataset id of the table to list.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project id of the table to list.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

tableId

Description : Required. Table id of the table to list.

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data  ⟶  projects/{+projectId}/datasets/{+datasetId}/tables/{+tableId}/data

▼ ▲ bigquery.tables.delete

Parameters :

datasetId

Description : Required. Dataset ID of the table to delete

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the table to delete

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

tableId

Description : Required. Table ID of the table to delete

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets/{datasetId}/tables/{tableId}  ⟶  projects/{+projectId}/datasets/{+datasetId}/tables/{+tableId}

▼ ▲ bigquery.tables.get

Parameters :

datasetId

Description : Required. Dataset ID of the requested table

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the requested table

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

tableId

Description : Required. Table ID of the requested table

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

view

Enum : TABLE_METADATA_VIEW_UNSPECIFIED  ⟶  FULL

Path : projects/{projectId}/datasets/{datasetId}/tables/{tableId}  ⟶  projects/{+projectId}/datasets/{+datasetId}/tables/{+tableId}

▼ ▲ bigquery.tables.insert

Parameters :

datasetId

Description : Required. Dataset ID of the new table

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the new table

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets/{datasetId}/tables  ⟶  projects/{+projectId}/datasets/{+datasetId}/tables

▼ ▲ bigquery.tables.list

Parameters :

datasetId

Description : Required. Dataset ID of the tables to list

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the tables to list

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets/{datasetId}/tables  ⟶  projects/{+projectId}/datasets/{+datasetId}/tables

▼ ▲ bigquery.tables.patch

Parameters :

datasetId

Description : Required. Dataset ID of the table to update

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the table to update

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

tableId

Description : Required. Table ID of the table to update

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets/{datasetId}/tables/{tableId}  ⟶  projects/{+projectId}/datasets/{+datasetId}/tables/{+tableId}

▼ ▲ bigquery.tables.update

Parameters :

datasetId

Description : Required. Dataset ID of the table to update

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

projectId

Description : Required. Project ID of the table to update

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

tableId

Description : Required. Table ID of the table to update

Location : path

Pattern : ^[^/]+$

Required : Yes

Type : string

Path : projects/{projectId}/datasets/{datasetId}/tables/{tableId}  ⟶  projects/{+projectId}/datasets/{+datasetId}/tables/{+tableId}