search

snowflakedb / dplyr-snowflakedb

SnowflakeDB backend for dplyr
Apache License 2.0
65 stars 25 forks source link

Compatibility issues with dplyr 1.0.3 #40

Open cettt opened 3 years ago

cettt commented 3 years ago

I am working with R 4.0.3 and dplyr 1.0.3. I am able to establish a connection with snowflake database. However, nothing seems to work afterwards.

Here is a small example:

library(dplyr)
library(dplyr.snowflakedb)
options(dplyr.jdbc.classpath = "path/snowflake-jdbc-3.12.9.jar")

my_con <- src_snowflakedb(
  user = "user", 
  password = "password", 
  account = "account",
  host = "host",
  opts = list(warehouse = "warehouse", db = 'db, schema = 'schema', 
              role = "role")
)

When I print my_con in console all available tables are shown, so the connection seems to work. However when I try anything else, like db_list_tables(my_con) I get an error:

Error in UseMethod("db_list_tables") : no applicable method for 'db_list_tables' applied to an object of class "c('src_snowflakedb', 'src_sql', 'src')"

Here is my session Info:

R version 4.0.3 (2020-10-10)
Platform: i386-w64-mingw32/i386 (32-bit)
Running under: Windows 10 x64 (build 17134)

Matrix products: default

locale:
[1] LC_COLLATE=German_Austria.1252  LC_CTYPE=German_Austria.1252    LC_MONETARY=German_Austria.1252 LC_NUMERIC=C                    LC_TIME=German_Austria.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] dplyr.snowflakedb_0.3.0 RJDBC_0.2-8             rJava_0.9-13            DBI_1.1.1               dplyr_1.0.3            

loaded via a namespace (and not attached):
 [1] dbplyr_2.0.0     assertthat_0.2.1 crayon_1.3.4     R6_2.5.0         lifecycle_0.2.0  magrittr_2.0.1   pillar_1.4.7     rlang_0.4.10     rstudioapi_0.13  vctrs_0.3.6      generics_0.1.0   ellipsis_0.3.1  
[13] tools_4.0.3      glue_1.4.2       purrr_0.3.4      compiler_4.0.3   pkgconfig_2.0.3  tidyselect_1.1.0 tibble_3.0.5
armenic commented 3 years ago

@etduwx, @gregrahn could you please confirm whether this repository is still maintained? Otherwise maybe it is better to switch to Python or other language?

armenic commented 3 years ago

see https://github.com/snowflakedb/dplyr-snowflakedb/issues/28 and switch to ODBC asap