Snowflake connection to Databricks error

Madman
New Contributor II

When I am trying to read snowflake table from my databricks notebook, it is giving the error as:

df1.read.format("snowflake") \

.options(**options) \

.option("query", "select * from abc") \

.save()

Getting below error

java.sql.SQLException: No suitable driver found for jdbc:snowflake://https://snowflake_username.snowflakecomputing.com

sfUrl="https://snowflake_username.snowflakecomputing.com"

I tried below possibilities for sfUrl:

1. Removed "https://" from sfUrl and tried with sfUrl="snowflake_username.snowflakecomputing.com"

2. Added "jdbc:snowflake" and tried as sfUrl="jdbc:snowflake://https://snowflake_username.snowflakecomputing.com"

3. Removed "https://" and added "jdbc:snowflake" and tried with sfUrl="jdbc:snowflake://snowflake_username.snowflakecomputing.com"

In all the cases I am getting the ame error. Can any one please help me with the correct solution?

Thank you very much in advance.