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.
Access control: For more information, see access control.
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 containing this table. | |
tableReference.projectId |
string |
[Required] The ID of the project containing this table. | |
tableReference.tableId |
string |
[Required] The ID of the table. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters. | |
| 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. Alternatively, try the standalone Explorer.