Database Reference
In-Depth Information
Unlike
Datasets.list()
,
Tables.list()
returns a count of the total
number of tables in the dataset, even if fewer are returned in the list
operation. If the list operation doesn't return all of the tables, this is due to
paging, not access control, since all tables in a dataset share the same ACL.
To conserve response size (because table schemas can be very large),
Tables.list()
doesn't return the full Table resource; it includes only the
table reference information. If you need to see the full Table resource, you
should call
Tables.get()
.
Following is a
curl
transcript showing a
tables.list()
request:
$
curl -H "$(python auth.py)" \
-
H "Content-Type: application/json" \
-
X GET \
"${TABLES_URL}?maxResults=1"
{
…
"nextPageToken": "table1",
"tables": [
{
"kind": "bigquery#table",
"id": "bigquery-e2e:scratch.table1",
"tableReference": {
"projectId": "bigquery-e2e",
"datasetId": "scratch",
"tableId": "table1"
}
}
],
"totalItems": 2
}
Tables.update()
The
Tables.update()
operation enables you to modify the mutable fields
of a table. The freely modifiable fields are the expiration time, friendly name,
and description (
expirationTime
,
friendlyName
, and
description
).
The schema can also be modified in certain limited ways.