Retrieve data from a table deprecated
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)page_size |
Number of items per page. |
table_info |
if known, the table information retrieved with
|
max_pages |
maximum number of pages to retrieve. Use |
warn |
If |
quiet |
if |
callback |
function called with single argument, the data from the current page of data |
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)
API documentation at https://cloud.google.com/bigquery/docs/reference/rest/v2/tabledata/list
## 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)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.