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:

Requirements

For a list of the operating systems supported by Snowflake clients, see Operating System Support.

Downloading the Driver

To download the driver:

  1. Go to the Maven Central Repository:

    https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc

  2. Click on the version that you need.

    The most recent version is not always at the end of the list. Versions are listed alphabetically, not numerically. For example, 3.10.x comes after 3.1.x, not after 3.9.x.

  3. Download the snowflake-jdbc-#.#.#.jar file. (You do not need to download the entire directory.)

Verifying the Driver Package Signature — Optional

To optionally verify the JDBC driver package signature:

  1. Download and import the latest Snowflake GPG public key from the public keyserver:

    $ gpg --keyserver hkp://keys.gnupg.net --recv-keys <GPG_KEY_ID>
    

    For <GPG_KEY_ID>, specify one of the following key IDs:

    JDBC Driver Version

    GPG Key ID

    3.12.13 and higher

    37C7086698CB005C

    3.6.26 through 3.12.12

    EC218558EABB25A1

    Up to 3.6.25

    93DB296A69BE019A

  2. Download the GPG signature along with the bash installer and verify the signature. For example:

    $ gpg --verify snowflake-jdbc-3.12.13.jar.asc snowflake-jdbc-3.12.13.jar
    gpg: Signature made Wed 22 Feb 2017 04:31:58 PM UTC using RSA key ID <gpg_key_id>
    gpg: Good signature from "Snowflake Computing <snowflake_gpg@snowflake.net>"

    Note

    Specify the correct version numbers for the JDBC driver package you are verifying. Version 3.12.13 is used in this example for illustration purposes only. The latest available version of the driver may be higher.

  3. 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 necessary tags to your pom.xml file. For example:

<groupId>net.snowflake</groupId>
<artifactId>snowflake-jdbc</artifactId>
<version>3.12.13</version>

Where the <version> tag specifies the version of the driver you wish to integrate. Note that version 3.12.13 is used in this example for illustration purposes only. The latest available version of the driver may be higher.

The developer notes are hosted along with the source code on GitHub.