Google BigQuery

Datasets: update

Requires authorization

Updates information in an existing dataset. The update method replaces the entire dataset resource, whereas the patch method only replaces fields that are provided in the submitted dataset resource. Try it now.

Warning: The specified access list completely overwrites the existing access list. If you specify an empty access list, you will revoke access to everyone except yourself; you cannot remove all owners from a dataset.

Access control: For more information, see access control.


HTTP request

PUT https://www.googleapis.com/bigquery/v2/projects/projectId/datasets/datasetId


Parameter name Value Description
Path parameters
datasetId string Dataset ID of the dataset being updated
projectId string Project ID of the dataset being updated


This request requires authorization with at least one of the following scopes (read more about authentication and authorization).


Request body

In the request body, supply a Datasets resource with the following properties:

Property name Value Description Notes
Required Properties
datasetReference.datasetId string [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
datasetReference.projectId string [Optional] The ID of the project containing this dataset.
Optional Properties
access[].domain string [Pick one] A domain to grant access to. Any users signed in with the domain specified will be granted the specified access. Example: "example.com". writable
access[].groupByEmail string [Pick one] An email address of a Google Group to grant access to. writable
access[].role string [Required] Describes the rights granted to the user specified by the other member of the access object. The following string values are supported: READER, WRITER, OWNER.

For more information about access control in BigQuery, see access control.
access[].specialGroup string [Pick one] A special group to grant access to.

Possible values include:
  • projectOwners: Owners of the enclosing project. 
  • projectReaders: Readers of the enclosing project. 
  • projectWriters: Writers of the enclosing project. 
  • allAuthenticatedUsers: All authenticated BigQuery users.
For more information about access control in BigQuery, see access control.
access[].userByEmail string [Pick one] An email address of a user to grant access to. For example: fred@example.com. writable
access[].view nested object [Pick one] A view from a different dataset to grant access to. Queries executed against that view will have read access to tables in this dataset. The role field is not required when this field is set. If that view is updated by any user, access to the view needs to be granted again via an update operation. writable
description string [Optional] A user-friendly description of the dataset. writable
friendlyName string [Optional] A descriptive name for the dataset. writable


If successful, this method returns a Datasets resource in the response body.

Try it!

Use the APIs Explorer below to call this method on live data and see the response.