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 .
