I have setup R studio on azure data bricks. My objective is to connect to snowflake cloud virtual warehouse from R to write processed data into it.
when trying to execute the following command
my_db<-src_snowflakedb(user = "username", password = "password",account= "myaccount",host = "myhost.cloud.snowflakecomputing.com",port = 443, opts = list(database = "mydb",warehouse = "mywarehouse",schema = "myschema"))
i get error as follows:
Error in .jfindClass(as.character(driverClass)) : java.lang.ClassNotFoundException
I am guessing that i am missing how to set classpath / java home in data bricks. The same code works in my desktop R studio.
any help pls. thanks.