Downloading/Integrating the JDBC Driver¶
The JDBC driver (
snowflake-jdbc) is provided as a JAR file, available as an artifact in Maven for download or integrating directly into your Java-based projects.
Before downloading or integrating the driver, you may want to first verify the version of the driver you are currently using. To verify your driver version, connect to Snowflake through a client application that uses the driver and check the driver version. If the application supports executing SQL queries, you can do this by calling the CURRENT_CLIENT function.
In this Topic:
Downloading the Driver¶
To download the driver, go to the Maven Central Repository:
Verifying the Driver Package Signature — Optional¶
To optionally verify the JDBC driver package signature:
Download and import the latest Snowflake GPG public key from the public keyserver:
$ gpg --keyserver hkp://keys.gnupg.net --recv-keys 93DB296A69BE019A
Download the GPG signature along with the bash installer and verify the signature:
$ gpg --verify snowflake-jdbc-3.4.2.jar.asc snowflake-jdbc-.3.4.2.jar gpg: Signature made Wed 22 Feb 2017 04:31:58 PM UTC using RSA key ID 93DB296A69BE019A gpg: Good signature from "Snowflake Computing <email@example.com>"
Make sure to specify the correct version numbers for the JDBC driver package you are verifying (3.4.2 is the latest version).
Your local environment can contain multiple GPG keys; however, for security reasons, Snowflake periodically rotates the public GPG key. As a best practice, we recommend deleting the existing public key after confirming that the latest key works with the latest signed package:
$ gpg --delete-key "Snowflake Computing"
Integrating the Driver into a Project¶
To integrate the driver into a project, add the following tags to your
<groupId>net.snowflake</groupId> <artifactId>snowflake-jdbc</artifactId> <version>3.4.2</version>
<version> tag specifies the version of the driver you wish to integrate (3.4.2 is the latest version).
The developer notes are hosted with the source code on GitHub.