We’re stoked to announce the release of bigrquery 1.5.0. bigrquery makes it easy to work with data stored in Google BigQuery, a hosted database for big data.
You can install it from CRAN with:
install.packages("bigrquery")This has been the first major update to bigrquery for a while, and is mostly about catching up with innovations elsewhere as well as squashing a bunch of smaller annoyances.
Here’s a summary of the biggest changes:
-
bigrquery is now MIT licensed.
-
Deprecated functions (i.e. those not starting with
bq_) have been removed. These have been superseded for a long time and were formally deprecated in bigrquery 1.3.0 (2020). -
bq_table_download()now returns unknown fields as character vectors. In particular, this means thatBIGNUMERICandJSONcolumns are downloaded into R for you to process as you wish.bq_table_download()now uses the clock package to parse dates, leading to a considerable performance improvement and correct parsing for dates prior to 1970-01-01. -
bigquery datasets and tables will now appear in the RStudio connections pane when connecting with
DBI::dbConnect(). -
DBI::dbAppendTable(),DBI::dbCreateTable(), andDBI::dbExecute()are now supported, andDBI::dbGetQuery()/DBI::dbSendQuery()support parameterised queries via theparamsargument.DBI::dbReadTable(),DBI::dbWriteTable(),DBI::dbExistsTable(),DBI::dbRemoveTable(), andDBI::dbListFields()now all work withDBI::Id(). -
bigrquery now uses 2nd edition of dbplyr interface and is compatible with dbplyr 2.4.0.
See the release notes for a full list of changes.
Acknowledgements
A big thanks to all 14 folks who helped make this release happen with questions, comments, and code: @abalter, @ablack3, @evanrollinsdrumline, @hadley, @husseyd, @jacobmpeters, @jennybc, @Kvit, @meztez, @mgirlich, @MichaelChirico, @mjbroerman, @ncuriale, and @rdavis120.