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://cloud.google.com/bigquery/docs/reference/rest/v2/tabledata/list
Examples
if (FALSE) {
billing_project <- "341409650721" # put your project number here
natal <- list_tabledata("publicdata", "samples", "natality", max_pages = 2,
page_size = 10)
dim(natal)
}