Please note that the contents of this offline web site may be out of date. To access the most recent documentation visit the online version .
Note that links that point to online resources are green in color and will open in a new window.
We would love it if you could give us feedback about this material by filling this form (You have to be online to fill it)



Tabledata

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.

Methods

The following methods are supported:

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

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 3.0 License , and code samples are licensed under the Apache 2.0 License . For details, see our Site Policies .

Authentication required

You need to be signed in with Google+ to do that.

Signing you in...

Google Developers needs your permission to do that.