Connecting to snowflake in databricks with sparklyr #3338
alejandrohagan
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Is there an equivalent way to use sparklyr to connect to a databricks instance replicating the below sparkR query?
otc_sparkr=SparkR::read.df(
source = "snowflake",
sfUrl = "xxx.xxx.xxx.com",
sfUser = dbutils.secrets.get(scope = "kv-cashflow-sandbox", key = "snowflake-pipeline-user"),
sfPassword = dbutils.secrets.get(scope = "kv-cashflow-sandbox", key = "snowflake-pipeline-password"),
Database = 'db_name',
Schema = 'schema.name' ,
Warehouse = 'wh.name',
query= "SELECT * FROM database.schema.name" ##query specification
)
Beta Was this translation helpful? Give feedback.
All reactions