Tabledata is used to return a slice of rows from a specified table. All columns are returned. Each row is actually a Tabledata resource; to get a slice of rows, you call bigquery.tabledata.list(). Specify a zero-based start row and a number of rows to retrieve in the list() request. Results are paged if the number of rows exceeds the maximum for a single page of data. The column order will be the order specified by the table schema.

For a list of methods for this resource, see the end of this page.

Resource representations

A JSON representation of a single row of table data. All columns specified by the table schema will be retrieved. See tabledata.list() for details about how the returned data is structured.


The following methods are supported:

Streams data into BigQuery one record at a time without needing to run a load job. For more information, see streaming data into BigQuery.
Retrieves table data from a specified set of rows. Requires the READER dataset role.

Monitor your resources on the go

Get the Google Cloud Console app to help you manage your projects.

Send feedback about...