通过Rscript到雪花的dbConnect出错(但不是R Studio)

Question

我已经使用ODBC驱动程序成功地从R Studio连接/查询了Snowflake。当我在Rgui.exe中尝试该代码时，它也可以正常工作。然而，在Rterm (或从批处理脚本调用rScript )中，它不会。Rterm返回以下错误：

OOB curl_easy_perform() failed: SSL peer certificate or SSH remote key was not OK

我的R代码是：

library(ROracle)
library(methods)

username <- keyring::key_list("blake-snowflake")[1,2]
password <- keyring::key_get("blake-snowflake", keyring::key_list("my-snowflake")[1,2])

### connect to EDW
con_snowflake <- dbConnect(
  odbc::odbc(), 
  "EDW_sample", 
  uid=username, 
  pwd=password)

Answer 1

我从使用ODBC切换到JDBC。

library(RJDBC)

jdbcDriver <- JDBC(driverClass="com.snowflake.client.jdbc.SnowflakeDriver", classPath = "..\\java\\snowflake-jdbc-3.7.2.jar") 

con_snowflake <- dbConnect(jdbcDriver, "jdbc:snowflake://xxx.snowflakecomputing.com/", keyring::key_list("my-snowflake")[1,2], keyring::key_get("my-snowflake", keyring::key_list("my-snowflake")[1,2]), db="db_name", schema="schema_name")

### read in data
query = readr::read_file("...\\query.sql")
df <- ROracle::dbGetQuery(con_snowflake, query)