Tables: update

Requires authorization

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

Required ACLs: To call this method, you must have one of the following rights:

Dataset WRITE
Dataset OWNER

Request

HTTP request

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

Parameters

Parameter name	Value	Description
Path parameters
`datasetId`	`string`	Dataset ID of the table to update
`projectId`	`string`	Project ID of the table to update
`tableId`	`string`	Table ID of the table to update

Authorization

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

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

Request body

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

Property name	Value	Description	Notes
Required Properties
`tableReference. datasetId`	`string`	[Required] The ID of the dataset that contains the table.
`tableReference. projectId`	`string`	[Required] The ID of the project that contains the table.
`tableReference. tableId`	`string`	[Required] The table ID.
Optional Properties
`description`	`string`	[Optional] A user-friendly description of this table.	writable
`friendlyName`	`string`	[Optional] A descriptive name for this table.	writable
`schema`	`nested object`	[Optional] Describes the schema of this table.	writable
`view`	`nested object`	[Optional] The view definition.	writable

Response

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

Try it!

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

Google BigQuery