Interface with Google BigQuery with Shiny Compatibility

Interface with 'Google BigQuery', see <> for more information. This package uses 'googleAuthR' so is compatible with similar packages, including 'Google Cloud Storage' (<>) for result extracts.

This is a package for interating with BigQuery from within R.

See the bigQueryR website for examples, details and tutorials.

This package is on CRAN, but to install the latest development version you can install from the cloudyr drat repository:

# latest stable version
install.packages("bigQueryR", repos = c(getOption("repos"), ""))

Or, to pull a potentially unstable version directly from GitHub:



bigQuery 0.3.2

  • Move to new batch endpoint (#41)
  • Remove travis env arg

bigQuery 0.3.1

  • Fix asynch job fail if user previously set.seed() (#37)
  • skip tests on CRAN causing error
  • fix warning in scope check (#40)

bigQueryR 0.3.0

  • Add support for realtime queries, useQueryCache = FALSE
  • Add support for standard SQL (#21)
  • Add support for hms/timestamp class uploads (#27)
  • Add support for partitioned tables (#28)
  • Fix bug that only returned one row for single column queries (#31 - thanks Rob)
  • Allow loading of data from Google Cloud Storage to BigQuery for large files
  • no error if delete non-existent table (#26)
  • Add auto authentication if set environment var BQ_AUTH_FILE to location of auth file
  • Add default project if set environment var BQ_DEFAULT_PROJECT_ID to project-id
  • Add default dataset if set environment var BQ_DEFAULT_DATASET to dataset-id
  • Add auto paging through table lists in bqr_list_tables() (#29)
  • Make it clearer when jobs resulted in errors in the job print methods
  • Migrate to using googleCloudStorageR for Cloud Storage stuff
  • Set default authentication scope to
  • Unit tests
  • Upload table will now correctly report errors
  • More user feedback on BigQuery jobs when running
  • Allow upload of data.frames asynchrnously
  • Allow auto-detection of schema for uploads

bigQueryR 0.2.0

  • Download asynch queries straight to disk via googleCloudStorageR

bigQueryR 0.1.0

  • Added a file to track changes to the package.
  • Initial release

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.


0.3.2 by Mark Edmondson, 7 months ago

Report a bug at

Browse source code at

Authors: Mark Edmondson [aut, cre], Hadley Wickham [ctb]

Documentation:   PDF Manual  

MIT + file LICENSE license

Imports googleAuthR, googleCloudStorageR, jsonlite, httr, assertthat

Suggests shiny, knitr, rmarkdown, testthat

Suggested by googleAnalyticsR.

See at CRAN