Snowflake connection to Databricks error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-07-2021 09:55 AM
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.
- Labels:
-
Data Ingestion & connectivity