Please use bq_table_download instead.

list_tabledata_callback calls the supplied callback with each page of data.

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

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)
# }