dbplyr issues with bigquery in r studio

86 views Asked by At

So I am taking an online course on data science and they want me to use r studio for bigquery manipulation.

I finally got the code to accept and authenticate my workspace, (by using dbplyr v2.1.1) however I continue to get an error when I go to write a sql-like query.

My code with dummy variables

library(tidyverse)
library(magrittr)
library(bigrquery)
devtools::install_version('dbplyr', version = '2.1.1')

con <-DBI::dbConnect(drv = bigquery(), project ="project1")
table1 <-tbl(con, "dataset1.table1")
table2 <-tbl(con, "dataset1.table2")

table2 %>% 
  select(variable1)

the error I get when running the query is:

Error in UseMethod("op_can_download") : no applicable method for 'op_can_download' applied to an object of class "NULL"

EDIT: Even when updating to dbplyr 2.4.0 it still returns the same error

EDIT: I installed dbplyr v2.3.4 and was able to get the code running. I found the trick on https://stackoverflow.com/a/77465186/23177253. It seems like the maintainers of dbplyr aren't keeping features updated in their x.x.0 releases.

0

There are 0 answers