# SnowFlake Connector JDBC error

**URL:** <https://community.dremio.com/t/snowflake-connector-jdbc-error/7594>\
**Category:** Uncategorized\
**Created:** [June 11, 2021, 4:22am UTC](https://community.dremio.com/t/snowflake-connector-jdbc-error/7594 "2021-06-11T04:22:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shardulsp](https://avatars.discourse-cdn.com/v4/letter/s/46a35a/32.png) [@Shardulsp](https://community.dremio.com/u/Shardulsp)\
**Post date:** [June 11, 2021, 4:22am UTC](https://community.dremio.com/t/snowflake-connector-jdbc-error/7594/1 "2021-06-11T04:22:07Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Shardulsp](https://avatars.discourse-cdn.com/v4/letter/s/46a35a/32.png) [@Shardulsp](https://community.dremio.com/u/Shardulsp)\
**Post date:** [June 11, 2021, 4:39am UTC](https://community.dremio.com/t/snowflake-connector-jdbc-error/7594/2 "2021-06-11T04:39:14Z")

</div>

> [@Shardulsp](#):
>
> net.snowflake.client.jdbc.SnowflakeDriver’ does not denote a valid java.sql.Driver

I fixed this issue by downloading the lastest snowflake jar file from this link :  
[https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/](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.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [June 11, 2021, 7:38am UTC](https://community.dremio.com/t/snowflake-connector-jdbc-error/7594/3 "2021-06-11T07:38:34Z")

</div>

Thanks for the update @Shardulsp
