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}