Snowflake JDBC Driver Download

Download the Snowflake JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the Snowflake JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Snowflake. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Snowflake driver uses its own syntax — see the connection details below.

The Snowflake JDBC driver

Snowflake is a cloud-native data warehouse built for scale, running on AWS, Azure, and Google Cloud. It features automatic scaling, zero-copy cloning, time travel, and a pay-per-query pricing model, making it the go-to platform for cloud analytics and data sharing.

The Snowflake JDBC URL

• Required File(s): snowflake-jdbc-xxx.jar
• Java Driver Class: net.snowflake.client.jdbc.SnowflakeDriver
• JDBC URL: jdbc:snowflake://HOST/?user=USER&[db=DB][&warehouse={WAREHOUSE}][&schema={SCHEMA}]
• Website: Snowflake

Download Snowflake JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager. The driver can also be found on the Snowflake website.

Set Up the Snowflake Connection

Snowflake has no port to open and no server to configure. The whole connection hinges on getting the account identifier into the host name, and on naming a warehouse.

1. Build the host from the account identifier. The host is always <account_identifier>.snowflakecomputing.com. The current form of that identifier is myorganization-myaccount, giving myorganization-myaccount.snowflakecomputing.com. Older accounts use an account locator with the region and cloud instead, as in xy12345.eu-central-1.snowflakecomputing.com. Both work — take whichever your account shows rather than assembling one by hand.
2. Name a warehouse. Storage and compute are separate in Snowflake, so a connection without a warehouse can read the catalog but cannot run a query. Give the warehouse, and the role if your user has more than one: a role that lacks USAGE on the warehouse produces an empty schema rather than an error.
3. Pick the authentication entry. The Connection Mode combo has five. Password is the default; External Browser opens your identity provider's page and is the one for Okta or any SAML single sign-on; Private Key File covers key-pair authentication; there are also OAuth and passcode entries for accounts using them.
4. Check the account's network policy. Where a network policy restricts which addresses may connect, your address has to be in it — the refusal happens before authentication. On a locked-down corporate network, the SYSTEM$ALLOWLIST function lists every host the driver needs to reach, which is what your network team will ask for.
5. Paste the URL into DbSchema. In the Connection Dialog set Connection Mode to Edit the JDBC URL Manually and paste the string you copied. The user and the password are entered in the first tab, not in the URL.

DbSchema and Snowflake

DbSchema connects to Snowflake warehouses and renders the multi-database, multi-schema object hierarchy as navigable ER diagrams. Use the Schema Documentation feature to generate HTML docs for Snowflake schemas that span multiple data domains.