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.