bigrquery (version 0.2.0)

list_tabledata: Retrieve data from a table.

Description

list_tabledata returns a single dataframe.

list_tabledata_callback calls the supplied callback with each page of data.

list_tabledata_iter returns a named list with functions next_ (fetches one chunk of rows), next_paged (fetches arbitrarily many rows using a specified page size), is_complete (checks if all rows have been fetched), get_schema (returns the schema of the table), and get_rows_fetched (returns the number of rows already fetched).

Usage

list_tabledata(project, dataset, table, page_size = 10000,
  table_info = NULL, max_pages = 10, warn = TRUE,
  quiet = getOption("bigrquery.quiet"))
list_tabledata_callback(project, dataset, table, callback, table_info = NULL,
  page_size = getOption("bigrquery.page.size"), max_pages = 10,
  warn = TRUE, quiet = getOption("bigrquery.quiet"))
list_tabledata_iter(project, dataset, table, table_info = NULL)

Arguments

project

project containing this table

dataset

dataset containing this table

table

name of the table

page_size

Number of items per page.

table_info

if known, the table information retrieved with get_table

max_pages

maximum number of pages to retrieve. Use Inf to retrieve the complete dataset.

warn

If TRUE, warn when there are rows remaining to be pulled down from database.

quiet

if FALSE, prints informative status messages.

callback

function called with single argument, the data from the current page of data

See Also

API documentation at https://developers.google.com/bigquery/docs/reference/v2/tabledata/list

Examples

billing_project <- "341409650721" # put your project number here
natal <- list_tabledata("publicdata", "samples", "natality", max_pages = 2,
  page_size = 10)
dim(natal)