SnowFlake Connector JDBC error

Hi ,
when I try connecting to my snowflake account from snowflake connector i am getting a error message “Could not connect to snowflake test, check your JDBC connection information and credentials.”

server.log:

java.lang.IllegalArgumentException: String ‘net.snowflake.client.jdbc.SnowflakeDriver’ does not denote a valid java.sql.Driver class name.
at com.dremio.exec.store.jdbc.DataSources.newGenericConnectionPoolDataSource(DataSources.java:60)
at com.dremio.exec.store.jdbc.conf.SnowflakeConf.newDataSource(SnowflakeConf.java:124)
at com.dremio.exec.store.jdbc.JdbcSchemaFetcherImpl.start(JdbcSchemaFetcherImpl.java:287)
at com.dremio.exec.store.jdbc.JdbcStoragePlugin.start(JdbcStoragePlugin.java:359)
at com.dremio.exec.catalog.ManagedStoragePlugin.lambda$newStartSupplier$1(ManagedStoragePlugin.java:523)
at com.dremio.exec.catalog.ManagedStoragePlugin.lambda$nameSupplier$3(ManagedStoragePlugin.java:591)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: net.snowflake.client.jdbc.SnowflakeDriver
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352)
at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at com.dremio.exec.store.jdbc.DataSources.newGenericConnectionPoolDataSource(DataSources.java:58)
… 9 common frames omitted

please help me with this issue

regards

I fixed this issue by downloading the lastest snowflake jar file from this link :
https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/

after downloading you need to paste this jar file in you /jars/3rdparty folder and restart snowflake.

Thanks for the update @Shardulsp

1 Like