list_tabledata: Retrieve data from a table deprecated

In wilpoole-essence/bigrquery: An Interface to Google's 'BigQuery' 'API'

Description

Please use bq_table_download instead.

list_tabledata_callback calls the supplied callback with each page of data.

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

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

Value

list_tabledata returns a single dataframe.

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),

• get_rows_fetched (returns the number of rows already fetched).

• get_rows (returns total number of rows)

See Also

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

Examples

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

## End(Not run)

wilpoole-essence/bigrquery documentation built on May 6, 2019, 8:06 p.m.