R studio on azure data bricks

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)[1]) : 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.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.