bigrquery
bigrquery copied to clipboard
Published
20 hours ago •
r-dbi
r-dbi
biqrquery not compatible with dbplyr 2.2.0
getting issues with dbplyr 2.2.0 having to use dbplyr 2.1.1 as work around. Unable to currently provide reprex as example but has also been noticed in #492.
Warning message:
“<BigQueryConnection> uses an old dbplyr interface
ℹ Please install a newer version of the package or contact the maintainer
This warning is displayed once every 8 hours.”
Applying predicate on the first 100 rows
Error in UseMethod("op_can_download"): no applicable method for 'op_can_download' applied to an object of class "NULL"
I also got this warning and error when updating to dbplyr 2.2.0.
Maybe this has to do with the version of R? What version of R are you running @jkylearmstrong ?
I'm running 4.1.0 and got this error:
suppressPackageStartupMessages(library(bigrquery))
suppressPackageStartupMessages(library(dbplyr))
suppressPackageStartupMessages(library(dplyr))
#> Warning: package 'dplyr' was built under R version 4.1.2
options(gargle_oauth_email = "[email protected]")
con <- DBI::dbConnect(
bigrquery::bigquery(),
project = "my_project",
dataset = "publicdata",
bigint = "integer64"
)
tbl(con, in_schema("samples", "natality"))
#> Warning: <BigQueryConnection> uses an old dbplyr interface
#> ℹ Please install a newer version of the package or contact the maintainer
#> This warning is displayed once every 8 hours.
#> Error in `signal_reason()`:
#> ! Invalid dataset ID "`samples`". Dataset IDs must be alphanumeric (plus underscores and dashes) and must be at most 1024 characters long. [invalid]
sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#> setting value
#> version R version 4.1.0 (2021-05-18)
#> os macOS Big Sur 10.16
#> system x86_64, darwin17.0
#> ui X11
#> language (EN)
#> collate sv_SE.UTF-8
#> ctype sv_SE.UTF-8
#> tz Europe/Stockholm
#> date 2022-06-07
#>
#> ─ Packages ───────────────────────────────────────────────────────────────────
#> package * version date lib source
#> askpass 1.1 2019-01-13 [2] CRAN (R 4.1.0)
#> assertthat 0.2.1 2019-03-21 [2] CRAN (R 4.1.0)
#> bigrquery * 1.4.0 2021-08-05 [1] CRAN (R 4.1.0)
#> bit 4.0.4 2020-08-04 [2] CRAN (R 4.1.0)
#> bit64 4.0.5 2020-08-30 [2] CRAN (R 4.1.0)
#> cli 3.3.0 2022-04-25 [1] CRAN (R 4.1.2)
#> crayon 1.5.0 2022-02-14 [1] CRAN (R 4.1.2)
#> curl 4.3.2 2021-06-23 [1] CRAN (R 4.1.0)
#> DBI 1.1.2 2021-12-20 [1] CRAN (R 4.1.0)
#> dbplyr * 2.2.0 2022-06-05 [1] CRAN (R 4.1.0)
#> digest 0.6.29 2021-12-01 [1] CRAN (R 4.1.0)
#> dplyr * 1.0.9 2022-04-28 [1] CRAN (R 4.1.2)
#> ellipsis 0.3.2 2021-04-29 [2] CRAN (R 4.1.0)
#> evaluate 0.15 2022-02-18 [1] CRAN (R 4.1.2)
#> fansi 1.0.2 2022-01-14 [1] CRAN (R 4.1.2)
#> fastmap 1.1.0 2021-01-25 [2] CRAN (R 4.1.0)
#> fs 1.5.2 2021-12-08 [1] CRAN (R 4.1.0)
#> gargle 1.2.0 2021-07-02 [1] CRAN (R 4.1.0)
#> generics 0.1.1.9000 2021-12-22 [1] Github (r-lib/generics@f6668da)
#> glue 1.6.2 2022-02-24 [1] CRAN (R 4.1.2)
#> highr 0.9 2021-04-16 [2] CRAN (R 4.1.0)
#> htmltools 0.5.2 2021-08-25 [1] CRAN (R 4.1.0)
#> httr 1.4.2 2020-07-20 [2] CRAN (R 4.1.0)
#> jsonlite 1.8.0 2022-02-22 [1] CRAN (R 4.1.2)
#> knitr 1.39 2022-04-26 [1] CRAN (R 4.1.2)
#> lifecycle 1.0.1 2021-09-24 [1] CRAN (R 4.1.0)
#> magrittr 2.0.3 2022-03-30 [1] CRAN (R 4.1.2)
#> openssl 1.4.4 2021-04-30 [2] CRAN (R 4.1.0)
#> pillar 1.7.0 2022-02-01 [1] CRAN (R 4.1.2)
#> pkgconfig 2.0.3 2019-09-22 [2] CRAN (R 4.1.0)
#> purrr 0.3.4 2020-04-17 [2] CRAN (R 4.1.0)
#> R.cache 0.15.0 2021-04-30 [1] CRAN (R 4.1.0)
#> R.methodsS3 1.8.1 2020-08-26 [1] CRAN (R 4.1.0)
#> R.oo 1.24.0 2020-08-26 [1] CRAN (R 4.1.0)
#> R.utils 2.11.0 2021-09-26 [1] CRAN (R 4.1.0)
#> R6 2.5.1 2021-08-19 [1] CRAN (R 4.1.0)
#> rappdirs 0.3.3 2021-01-31 [2] CRAN (R 4.1.0)
#> Rcpp 1.0.8.3 2022-03-17 [1] CRAN (R 4.1.2)
#> reprex 2.0.0 2021-04-02 [2] CRAN (R 4.1.0)
#> rlang 1.0.2 2022-03-04 [1] CRAN (R 4.1.2)
#> rmarkdown 2.14 2022-04-25 [1] CRAN (R 4.1.0)
#> rstudioapi 0.13 2020-11-12 [2] CRAN (R 4.1.0)
#> sessioninfo 1.1.1 2018-11-05 [2] CRAN (R 4.1.0)
#> stringi 1.7.6 2021-11-29 [1] CRAN (R 4.1.0)
#> stringr 1.4.0 2019-02-10 [2] CRAN (R 4.1.0)
#> styler 1.7.0 2022-03-13 [1] CRAN (R 4.1.0)
#> tibble 3.1.6 2021-11-07 [1] CRAN (R 4.1.0)
#> tidyselect 1.1.2 2022-02-21 [1] CRAN (R 4.1.2)
#> utf8 1.2.2 2021-07-24 [1] CRAN (R 4.1.0)
#> vctrs 0.4.1 2022-04-13 [1] CRAN (R 4.1.2)
#> withr 2.5.0 2022-03-03 [1] CRAN (R 4.1.2)
#> xfun 0.31 2022-05-10 [1] CRAN (R 4.1.2)
#> yaml 2.3.5 2022-02-21 [1] CRAN (R 4.1.2)
#>
#> [1] /Users/filip.wastberg/Library/R/x86_64/4.1/library
#> [2] /Library/Frameworks/R.framework/Versions/4.1/Resources/library
Created on 2022-06-07 by the reprex package (v2.0.0)
Just adding a quick reprex (though the data is not public) with some examples of functions that do work.
options(httr_oauth_cache = FALSE)
options(gargle_oauth_cache = FALSE)
library(DBI)
library(dplyr)
#>
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#>
#> filter, lag
#> The following objects are masked from 'package:base':
#>
#> intersect, setdiff, setequal, union
library(dbplyr)
#>
#> Attaching package: 'dbplyr'
#> The following objects are masked from 'package:dplyr':
#>
#> ident, sql
library(bigrquery)
x = as_bq_table("streamline-resources.covid_jhu.covid_jhu_cases")
project = x$project
dataset = x$dataset
table = x$table
df = bq_table_download(x, n_max = 10)
df
#> # A tibble: 10 × 14
#> UID iso2 iso3 code3 FIPS Admin2 Province_State Country_Region Lat
#> <dbl> <chr> <chr> <dbl> <dbl> <chr> <chr> <chr> <dbl>
#> 1 316 GU GUM 316 66 <NA> Guam US 13.4
#> 2 316 GU GUM 316 66 <NA> Guam US 13.4
#> 3 316 GU GUM 316 66 <NA> Guam US 13.4
#> 4 316 GU GUM 316 66 <NA> Guam US 13.4
#> 5 316 GU GUM 316 66 <NA> Guam US 13.4
#> 6 316 GU GUM 316 66 <NA> Guam US 13.4
#> 7 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 8 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 9 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 10 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> # … with 5 more variables: Long_ <dbl>, Combined_Key <chr>, date <date>,
#> # cases <dbl>, streamline_update_time <dttm>
con = DBI::dbConnect(bigrquery::bigquery(), project = project)
res = con %>%
dplyr::tbl(paste0(dataset, ".", table))
#> Warning: <BigQueryConnection> uses an old dbplyr interface
#> ℹ Please install a newer version of the package or contact the maintainer
#> This warning is displayed once every 8 hours.
res
#> Error in UseMethod("op_can_download"): no applicable method for 'op_can_download' applied to an object of class "NULL"
con = DBI::dbConnect(bigrquery::bigquery(), project = project,
dataset = dataset)
dbListTables(con)
#> [1] "covid_jhu_cases"
res = con %>%
dplyr::tbl(table)
res
#> Error in UseMethod("op_can_download"): no applicable method for 'op_can_download' applied to an object of class "NULL"
dbReadTable(con, table, n_max = 10)
#> # A tibble: 10 × 14
#> UID iso2 iso3 code3 FIPS Admin2 Province_State Country_Region Lat
#> <dbl> <chr> <chr> <dbl> <dbl> <chr> <chr> <chr> <dbl>
#> 1 316 GU GUM 316 66 <NA> Guam US 13.4
#> 2 316 GU GUM 316 66 <NA> Guam US 13.4
#> 3 316 GU GUM 316 66 <NA> Guam US 13.4
#> 4 316 GU GUM 316 66 <NA> Guam US 13.4
#> 5 316 GU GUM 316 66 <NA> Guam US 13.4
#> 6 316 GU GUM 316 66 <NA> Guam US 13.4
#> 7 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 8 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 9 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 10 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> # … with 5 more variables: Long_ <dbl>, Combined_Key <chr>, date <date>,
#> # cases <dbl>, streamline_update_time <dttm>
Created on 2022-06-28 by the reprex package (v2.0.1)
Session info
sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#> setting value
#> version R version 4.1.2 (2021-11-01)
#> os Ubuntu 20.04.3 LTS
#> system x86_64, linux-gnu
#> ui X11
#> language (EN)
#> collate en_US.UTF-8
#> ctype en_US.UTF-8
#> tz Etc/UTC
#> date 2022-06-28
#> pandoc 2.14.0.3 @ /usr/lib/rstudio-server/bin/pandoc/ (via rmarkdown)
#>
#> ─ Packages ───────────────────────────────────────────────────────────────────
#> package * version date (UTC) lib source
#> assertthat 0.2.1 2019-03-21 [1] RSPM (R 4.1.0)
#> bigrquery * 1.4.0 2021-08-05 [1] RSPM (R 4.1.0)
#> bit 4.0.4 2020-08-04 [1] RSPM (R 4.1.0)
#> bit64 4.0.5 2020-08-30 [1] RSPM (R 4.1.0)
#> cli 3.3.0 2022-04-25 [1] RSPM (R 4.1.0)
#> crayon 1.5.1 2022-03-26 [1] RSPM (R 4.1.0)
#> curl 4.3.2 2021-06-23 [1] RSPM (R 4.1.0)
#> DBI * 1.1.3 2022-06-18 [1] RSPM (R 4.1.0)
#> dbplyr * 2.2.1 2022-06-27 [1] RSPM (R 4.1.0)
#> digest 0.6.29 2021-12-01 [1] RSPM (R 4.1.0)
#> dplyr * 1.0.9 2022-04-28 [1] RSPM (R 4.1.0)
#> ellipsis 0.3.2 2021-04-29 [1] RSPM (R 4.1.0)
#> evaluate 0.15 2022-02-18 [1] RSPM (R 4.1.0)
#> fansi 1.0.3 2022-03-24 [1] RSPM (R 4.1.0)
#> fastmap 1.1.0 2021-01-25 [1] RSPM (R 4.1.0)
#> fs 1.5.2 2021-12-08 [1] RSPM (R 4.1.0)
#> gargle 1.2.0 2021-07-02 [1] RSPM (R 4.1.0)
#> generics 0.1.2 2022-01-31 [1] RSPM (R 4.1.0)
#> glue 1.6.2 2022-02-24 [1] RSPM (R 4.1.0)
#> highr 0.9 2021-04-16 [1] RSPM (R 4.1.0)
#> hms 1.1.1 2021-09-26 [1] RSPM (R 4.1.0)
#> htmltools 0.5.2 2021-08-25 [1] RSPM (R 4.1.0)
#> httr 1.4.3 2022-05-04 [1] RSPM (R 4.1.0)
#> jsonlite 1.8.0 2022-02-22 [1] RSPM (R 4.1.0)
#> knitr 1.39 2022-04-26 [1] RSPM (R 4.1.0)
#> lifecycle 1.0.1 2021-09-24 [1] RSPM (R 4.1.0)
#> magrittr 2.0.3 2022-03-30 [1] RSPM (R 4.1.0)
#> pillar 1.7.0 2022-02-01 [1] RSPM (R 4.1.0)
#> pkgconfig 2.0.3 2019-09-22 [1] RSPM (R 4.1.0)
#> purrr 0.3.4 2020-04-17 [1] RSPM (R 4.1.0)
#> R.cache 0.15.0 2021-04-30 [1] RSPM (R 4.1.0)
#> R.methodsS3 1.8.2 2022-06-13 [1] RSPM (R 4.1.0)
#> R.oo 1.25.0 2022-06-12 [1] RSPM (R 4.1.0)
#> R.utils 2.11.0 2021-09-26 [1] RSPM (R 4.1.0)
#> R6 2.5.1 2021-08-19 [1] RSPM (R 4.1.0)
#> Rcpp 1.0.8.3 2022-03-17 [1] RSPM (R 4.1.0)
#> readr 2.1.2 2022-01-30 [1] RSPM (R 4.1.0)
#> reprex 2.0.1 2021-08-05 [1] RSPM (R 4.1.0)
#> rlang 1.0.3 2022-06-27 [1] RSPM (R 4.1.0)
#> rmarkdown 2.14 2022-04-25 [1] RSPM (R 4.1.0)
#> rstudioapi 0.13 2020-11-12 [1] RSPM (R 4.1.0)
#> sessioninfo 1.2.2 2021-12-06 [1] RSPM (R 4.1.0)
#> stringi 1.7.6 2021-11-29 [1] RSPM (R 4.1.0)
#> stringr 1.4.0 2019-02-10 [1] RSPM (R 4.1.0)
#> styler 1.7.0 2022-03-13 [1] RSPM (R 4.1.0)
#> tibble 3.1.7 2022-05-03 [1] RSPM (R 4.1.0)
#> tidyselect 1.1.2 2022-02-21 [1] RSPM (R 4.1.0)
#> tzdb 0.3.0 2022-03-28 [1] RSPM (R 4.1.0)
#> utf8 1.2.2 2021-07-24 [1] RSPM (R 4.1.0)
#> vctrs 0.4.1 2022-04-13 [1] RSPM (R 4.1.0)
#> withr 2.5.0 2022-03-03 [1] RSPM (R 4.1.0)
#> xfun 0.31 2022-05-10 [1] RSPM (R 4.1.0)
#> yaml 2.3.5 2022-02-21 [1] RSPM (R 4.1.0)
#>
#> [1] /usr/local/lib/R/site-library
#> [2] /usr/local/lib/R/library
#>
#> ──────────────────────────────────────────────────────────────────────────────
Showing that 2.1.1 works fine with this still
You can use remotes::install_version if you want to revert:
options(httr_oauth_cache = FALSE)
options(gargle_oauth_cache = FALSE)
remotes::install_version("dbplyr", "2.1.1")
#> Downloading package from url: https://packagemanager.rstudio.com/cran/__linux__/focal/latest/src/contrib/Archive/dbplyr/dbplyr_2.1.1.tar.gz
#> Installing package into '/usr/local/lib/R/site-library'
#> (as 'lib' is unspecified)
library(DBI)
library(dplyr)
#>
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#>
#> filter, lag
#> The following objects are masked from 'package:base':
#>
#> intersect, setdiff, setequal, union
library(dbplyr)
#>
#> Attaching package: 'dbplyr'
#> The following objects are masked from 'package:dplyr':
#>
#> ident, sql
library(bigrquery)
x = as_bq_table("streamline-resources.covid_jhu.covid_jhu_cases")
project = x$project
dataset = x$dataset
table = x$table
df = bq_table_download(x, n_max = 10)
df
#> # A tibble: 10 × 14
#> UID iso2 iso3 code3 FIPS Admin2 Province_State Country_Region Lat
#> <dbl> <chr> <chr> <dbl> <dbl> <chr> <chr> <chr> <dbl>
#> 1 316 GU GUM 316 66 <NA> Guam US 13.4
#> 2 316 GU GUM 316 66 <NA> Guam US 13.4
#> 3 316 GU GUM 316 66 <NA> Guam US 13.4
#> 4 316 GU GUM 316 66 <NA> Guam US 13.4
#> 5 316 GU GUM 316 66 <NA> Guam US 13.4
#> 6 316 GU GUM 316 66 <NA> Guam US 13.4
#> 7 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 8 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 9 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 10 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> # … with 5 more variables: Long_ <dbl>, Combined_Key <chr>, date <date>,
#> # cases <dbl>, streamline_update_time <dttm>
con = DBI::dbConnect(bigrquery::bigquery(), project = project)
res = con %>%
dplyr::tbl(paste0(dataset, ".", table))
res
#> # Source: table<covid_jhu.covid_jhu_cases> [?? x 14]
#> # Database: BigQueryConnection
#> UID iso2 iso3 code3 FIPS Admin2 Province_State Country_Region Lat
#> <dbl> <chr> <chr> <dbl> <dbl> <chr> <chr> <chr> <dbl>
#> 1 316 GU GUM 316 66 <NA> Guam US 13.4
#> 2 316 GU GUM 316 66 <NA> Guam US 13.4
#> 3 316 GU GUM 316 66 <NA> Guam US 13.4
#> 4 316 GU GUM 316 66 <NA> Guam US 13.4
#> 5 316 GU GUM 316 66 <NA> Guam US 13.4
#> 6 316 GU GUM 316 66 <NA> Guam US 13.4
#> 7 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 8 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 9 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 10 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> # … with more rows, and 5 more variables: Long_ <dbl>, Combined_Key <chr>,
#> # date <date>, cases <dbl>, streamline_update_time <dttm>
con = DBI::dbConnect(bigrquery::bigquery(), project = project,
dataset = dataset)
dbListTables(con)
#> [1] "covid_jhu_cases"
res = con %>%
dplyr::tbl(table)
res
#> # Source: table<covid_jhu_cases> [?? x 14]
#> # Database: BigQueryConnection
#> UID iso2 iso3 code3 FIPS Admin2 Province_State Country_Region Lat
#> <dbl> <chr> <chr> <dbl> <dbl> <chr> <chr> <chr> <dbl>
#> 1 316 GU GUM 316 66 <NA> Guam US 13.4
#> 2 316 GU GUM 316 66 <NA> Guam US 13.4
#> 3 316 GU GUM 316 66 <NA> Guam US 13.4
#> 4 316 GU GUM 316 66 <NA> Guam US 13.4
#> 5 316 GU GUM 316 66 <NA> Guam US 13.4
#> 6 316 GU GUM 316 66 <NA> Guam US 13.4
#> 7 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 8 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 9 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 10 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> # … with more rows, and 5 more variables: Long_ <dbl>, Combined_Key <chr>,
#> # date <date>, cases <dbl>, streamline_update_time <dttm>
dbReadTable(con, table, n_max = 10)
#> # A tibble: 10 × 14
#> UID iso2 iso3 code3 FIPS Admin2 Province_State Country_Region Lat
#> <dbl> <chr> <chr> <dbl> <dbl> <chr> <chr> <chr> <dbl>
#> 1 316 GU GUM 316 66 <NA> Guam US 13.4
#> 2 316 GU GUM 316 66 <NA> Guam US 13.4
#> 3 316 GU GUM 316 66 <NA> Guam US 13.4
#> 4 316 GU GUM 316 66 <NA> Guam US 13.4
#> 5 316 GU GUM 316 66 <NA> Guam US 13.4
#> 6 316 GU GUM 316 66 <NA> Guam US 13.4
#> 7 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 8 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 9 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> 10 84019009 US USA 840 19009 Audubon Iowa US 41.7
#> # … with 5 more variables: Long_ <dbl>, Combined_Key <chr>, date <date>,
#> # cases <dbl>, streamline_update_time <dttm>
Created on 2022-06-28 by the reprex package (v2.0.1)
Session info
sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#> setting value
#> version R version 4.1.2 (2021-11-01)
#> os Ubuntu 20.04.3 LTS
#> system x86_64, linux-gnu
#> ui X11
#> language (EN)
#> collate en_US.UTF-8
#> ctype en_US.UTF-8
#> tz Etc/UTC
#> date 2022-06-28
#> pandoc 2.14.0.3 @ /usr/lib/rstudio-server/bin/pandoc/ (via rmarkdown)
#>
#> ─ Packages ───────────────────────────────────────────────────────────────────
#> package * version date (UTC) lib source
#> assertthat 0.2.1 2019-03-21 [1] RSPM (R 4.1.0)
#> bigrquery * 1.4.0 2021-08-05 [1] RSPM (R 4.1.0)
#> bit 4.0.4 2020-08-04 [1] RSPM (R 4.1.0)
#> bit64 4.0.5 2020-08-30 [1] RSPM (R 4.1.0)
#> cli 3.3.0 2022-04-25 [1] RSPM (R 4.1.0)
#> crayon 1.5.1 2022-03-26 [1] RSPM (R 4.1.0)
#> curl 4.3.2 2021-06-23 [1] RSPM (R 4.1.0)
#> DBI * 1.1.3 2022-06-18 [1] RSPM (R 4.1.0)
#> dbplyr * 2.1.1 2021-04-06 [1] RSPM (R 4.1.2)
#> digest 0.6.29 2021-12-01 [1] RSPM (R 4.1.0)
#> dplyr * 1.0.9 2022-04-28 [1] RSPM (R 4.1.0)
#> ellipsis 0.3.2 2021-04-29 [1] RSPM (R 4.1.0)
#> evaluate 0.15 2022-02-18 [1] RSPM (R 4.1.0)
#> fansi 1.0.3 2022-03-24 [1] RSPM (R 4.1.0)
#> fastmap 1.1.0 2021-01-25 [1] RSPM (R 4.1.0)
#> fs 1.5.2 2021-12-08 [1] RSPM (R 4.1.0)
#> gargle 1.2.0 2021-07-02 [1] RSPM (R 4.1.0)
#> generics 0.1.2 2022-01-31 [1] RSPM (R 4.1.0)
#> glue 1.6.2 2022-02-24 [1] RSPM (R 4.1.0)
#> highr 0.9 2021-04-16 [1] RSPM (R 4.1.0)
#> hms 1.1.1 2021-09-26 [1] RSPM (R 4.1.0)
#> htmltools 0.5.2 2021-08-25 [1] RSPM (R 4.1.0)
#> httr 1.4.3 2022-05-04 [1] RSPM (R 4.1.0)
#> jsonlite 1.8.0 2022-02-22 [1] RSPM (R 4.1.0)
#> knitr 1.39 2022-04-26 [1] RSPM (R 4.1.0)
#> lifecycle 1.0.1 2021-09-24 [1] RSPM (R 4.1.0)
#> magrittr 2.0.3 2022-03-30 [1] RSPM (R 4.1.0)
#> pillar 1.7.0 2022-02-01 [1] RSPM (R 4.1.0)
#> pkgconfig 2.0.3 2019-09-22 [1] RSPM (R 4.1.0)
#> purrr 0.3.4 2020-04-17 [1] RSPM (R 4.1.0)
#> R.cache 0.15.0 2021-04-30 [1] RSPM (R 4.1.0)
#> R.methodsS3 1.8.2 2022-06-13 [1] RSPM (R 4.1.0)
#> R.oo 1.25.0 2022-06-12 [1] RSPM (R 4.1.0)
#> R.utils 2.11.0 2021-09-26 [1] RSPM (R 4.1.0)
#> R6 2.5.1 2021-08-19 [1] RSPM (R 4.1.0)
#> Rcpp 1.0.8.3 2022-03-17 [1] RSPM (R 4.1.0)
#> readr 2.1.2 2022-01-30 [1] RSPM (R 4.1.0)
#> remotes 2.4.2 2021-11-30 [1] RSPM (R 4.1.0)
#> reprex 2.0.1 2021-08-05 [1] RSPM (R 4.1.0)
#> rlang 1.0.3 2022-06-27 [1] RSPM (R 4.1.0)
#> rmarkdown 2.14 2022-04-25 [1] RSPM (R 4.1.0)
#> rstudioapi 0.13 2020-11-12 [1] RSPM (R 4.1.0)
#> sessioninfo 1.2.2 2021-12-06 [1] RSPM (R 4.1.0)
#> stringi 1.7.6 2021-11-29 [1] RSPM (R 4.1.0)
#> stringr 1.4.0 2019-02-10 [1] RSPM (R 4.1.0)
#> styler 1.7.0 2022-03-13 [1] RSPM (R 4.1.0)
#> tibble 3.1.7 2022-05-03 [1] RSPM (R 4.1.0)
#> tidyselect 1.1.2 2022-02-21 [1] RSPM (R 4.1.0)
#> tzdb 0.3.0 2022-03-28 [1] RSPM (R 4.1.0)
#> utf8 1.2.2 2021-07-24 [1] RSPM (R 4.1.0)
#> vctrs 0.4.1 2022-04-13 [1] RSPM (R 4.1.0)
#> withr 2.5.0 2022-03-03 [1] RSPM (R 4.1.0)
#> xfun 0.31 2022-05-10 [1] RSPM (R 4.1.0)
#> yaml 2.3.5 2022-02-21 [1] RSPM (R 4.1.0)
#>
#> [1] /usr/local/lib/R/site-library
#> [2] /usr/local/lib/R/library
#>
#> ──────────────────────────────────────────────────────────────────────────────
@mgirlich do you have any suggestions on what needs to be done to support dbplyr 2.2?
I'm a little confused, I'm still getting the warning upon creating a connection, but none of the errors, the actual functionality seems to be fine.
On Windows, with dbplyr 2.3.0 and bigrquery 1.4.1 I get the warning:
#> Warning: BigQueryConnection uses an old dbplyr interface #> ℹ Please install a newer version of the package or contact the maintainer #> This warning is displayed once every 8 hours.
...upon connecting to a table with tbl(), but I can access the data just fine. A little confused as to why I'd still be seeing the warning.
EDIT: Ah, ok I see in the pull request that addressed this they mention that the warning is still present for some reason. Glad to know I'm not crazy, but the persistent warning might cause some confusion, I think.