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.