Snowflake JDBC Driver
.. image:: https://github.com/snowflakedb/snowflake-jdbc/workflows/Build%20and%20Test/badge.svg?branch=master :target: https://github.com/snowflakedb/snowflake-jdbc/actions?query=workflow%3A%22Build+and+Test%22+branch%3Amaster
.. image:: http://img.shields.io/:license-Apache%202-brightgreen.svg :target: http://www.apache.org/licenses/LICENSE-2.0.txt
.. image:: https://maven-badges.herokuapp.com/maven-central/net.snowflake/snowflake-jdbc/badge.svg?style=plastic :target: http://repo2.maven.org/maven2/net/snowflake/snowflake-jdbc/
Snowflake provides a JDBC type 4 driver that supports core functionality, allowing Java program to connect to Snowflake.
The Snowflake JDBC driver requires Java 1.8 or higher. If the minimum required version of Java is not installed on the client machines where the JDBC driver is installed, you must install either Oracle Java or OpenJDK.
Add following code block as a dependency
.. code-block:: xml
<dependency>
<groupId>net.snowflake</groupId>
<artifactId>snowflake-jdbc</artifactId>
<version>{version}</version>
</dependency>
.. code-block:: bash
git clone https://github.com/snowflakedb/snowflake-jdbc.git
.. code-block:: bash
mvn install
.. code-block:: java
Class.forName("net.snowflake.client.jdbc.SnowflakeDriver")
javax.sql.DataSource interface is implemented by class
.. code-block:: java
net.snowflake.client.jdbc.SnowflakeBasicDataSource
US(West) Region:
.. code-block:: bash
jdbc:snowflake://<account>.snowflakecomputing.com/?<connection_params>
EU(Frankfurt) Region:
.. code-block:: bash
jdbc:snowflake://<account>.eu-central-1.snowflakecomputing.com/?<connection_params>
For detailed documentation, please refer to https://docs.snowflake.net/manuals/user-guide/jdbc.html
Run the maven command to check the coding style.
.. code-block:: bash
mvn -P check-style verify
Follow the instruction if any error occurs or run this command to fix the formats.
.. code-block:: bash
mvn com.coveo:fmt-maven-plugin:format
You may import the coding style from IntelliJ so that the coding style can be applied on IDE:
google-java-format
plugin.google-java-format
for the JDBC project.Set the environment variables to specify the target database.
.. code-block:: bash
export SNOWFLAKE_TEST_HOST=<your_host>
export SNOWFLAKE_TEST_ACCOUNT=<your_account>
export SNOWFLAKE_TEST_USER=<your_user>
export SNOWFLAKE_TEST_PASSWORD=<your_password>
export SNOWFLAKE_TEST_DATABASE=<your_database>
export SNOWFLAKE_TEST_SCHEMA=<your_schema>
export SNOWFLAKE_TEST_WAREHOUSE=<your_warehouse>
export SNOWFLAKE_TEST_ROLE=<your_role>
Run the maven verify
goal.
.. code-block:: bash
mvn -DjenkinsIT -DtestCategory=net.snowflake.client.category.<category> verify
where category
is the class name under the package net.snowflake.client.category
.
The test cases are fallen into a couple of criterias:
Test
. They run part of the JDBC build jobs.IT
. They run part of the verify
maven goal along with the test category specified by the parameter testCategory
having net.snowflake.client.category
classes.Manual
. They don't run in the CI but you can run them manually.Aside from the general test criterias, the test case class names ending with LatestIT
run only with the latest JDBC driver.
The main motivation behind is to skip those tests for the old JDBC driver. See ./TestOnly
directory for further information.
Feel free to file an issue or submit a PR here for general cases. For official support, contact Snowflake support at: https://community.snowflake.com/s/article/How-To-Submit-a-Support-Case-in-Snowflake-Lodge