sqlsnowflake-cloud-data-platformoracle-sql-data-modeler

Snowflake JDBC drivers - use with Oracle SQL Developer Data Modeler


I am having trouble connecting Oracle Data Modeler to a Snowflake database using a JDBC driver.

I am hoping someone can share some trouble shooting tips with me to help solve my problem.

The error I am getting when I try to test the connection is

"Status : Failure -Test failed: Driver class not found.

Verify the Driver location"

I have downloaded the jar file from the nominated spot in the Snowflake documentation.

I am able to add the jar file to Tools->Preferences->Data Model->Third Party JDBC Drivers.

When I add the data source using File->Import->Data Dictionary using

url - jdbc:snowflake://.ap-southeast-2.snowflakecomputing.com driver class - net.snowflake.client.jdbc.SnowflakeDriver I get the error when I try to Test.

I suppose the hint if 'Verify the Driver location' but didn't I specify that when I set up my preferences.

Is there a trick with path or another variable that helps with this problem?

Thanks in advance.


Solution

  • Don't forget to use net.snowflake.client.jdbc.SnowflakeDriver as the driver class in your JDBC application. Also, your connection string should have the following syntax: jdbc:snowflake://account_name.snowflakecomputing.com