Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Compatibility issues with dplyr 1.0.3 #40

Open
cettt opened this issue Jan 21, 2021 · 2 comments
Open

Compatibility issues with dplyr 1.0.3 #40

cettt opened this issue Jan 21, 2021 · 2 comments

Comments

@cettt
Copy link

cettt commented Jan 21, 2021

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
Copy link

armenic commented Jan 25, 2021

@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
Copy link

armenic commented Jan 26, 2021

see #28 and switch to ODBC asap

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants