These submit a query (using bq_perform_query()) and then wait for it complete (with bq_job_wait()). All BigQuery queries save their results into a table (temporary or otherwise), so these functions return a bq_table which you can then query for more information.

bq_project_query(x, query, destination_table = NULL, ..., quiet = NA)

bq_dataset_query(x, query, destination_table = NULL, ...,
  billing = NULL, quiet = NA)



Either a project (a string) or a bq_dataset.


SQL query string.


A bq_table where results should be stored. If not supplied, results will be saved to a temporary table that lives in a special dataset. You must supply this parameter for large queries (> 128 MB compressed).


Passed on to bq_perform_query()


If FALSE, displays progress bar; if TRUE is silent; if NA displays progress bar only for long-running jobs.


If you query a dataset that you only have read access for, such as a public dataset, you must also submit a billing project.


A bq_table


if (bq_testable()) { # Querying a project requires full name in query tb <- bq_project_query( bq_test_project(), "SELECT count(*) FROM publicdata.samples.natality" ) bq_table_fields(tb) bq_table_download(tb) # Querying a dataset sets default dataset so you can use bare table name, # but for public data, you'll need to set a project to bill. ds <- bq_dataset("publicdata", "samples") tb <- bq_dataset_query(ds, query = "SELECT count(*) FROM natality", billing = bq_test_project() ) bq_table_download(tb) tb <- bq_dataset_query(ds, query = "SELECT count(*) FROM natality WHERE state = @state", parameters = list(state = "KS"), billing = bq_test_project() ) bq_table_download(tb) }