How to Connect Snowflake to DBeaver

Galaxy Glossary

How do I connect Snowflake to DBeaver?

Establishes a JDBC link from DBeaver to a Snowflake warehouse so you can browse objects and run SQL.

Welcome to the Galaxy, Guardian!
You'll be receiving a confirmation email

Follow us on twitter :)

Oops! Something went wrong while submitting the form.

Description

Example H2

Example H3

What credentials are required?

You need your Snowflake account name (e.g., acme.us-east-1), user, password, role, default warehouse, database, and schema. Generate a network policy or use SSO if your org enforces it.

How do you add a Snowflake connection in DBeaver?

1. Install the Snowflake driver

Open DBeaver ➜ Database ➜ Driver Manager ➜ Add ➜ Select “Snowflake” ➜ Download. The driver bundle ships with the latest JDBC library.

2. Build the JDBC URL

Format: jdbc:snowflake://<account>.snowflakecomputing.com/?warehouse=<wh>&db=<db>&schema=<schema>&role=<role>. Supply user & password (or key-pair/SSO) in the Authentication tab.

3. Test and save

Click “Test Connection.” A green check confirms driver load and network reachability. Hit “Finish” to store the profile.

How can you verify access with an e-commerce query?

Open a SQL Editor and run SELECT * FROM Customers LIMIT 10;. Results should appear in the grid, proving the session’s default database objects are reachable.

What are best practices for stable sessions?

Pin a small warehouse for ad-hoc work to avoid queueing. Enable “Keep-alive” in the driver’s properties so idle IDE tabs don’t drop. Use CLIENT_SESSION_KEEP_ALIVE=true for long analyses.

Common mistakes and quick fixes

Wrong account URL. Remove the extra region string—acme.us-east-1, not acme.us-east-1.snowflakecomputing.com. Mismatch throws HTTP 403.

Warehouse spelling errors. The JDBC driver won’t auto-create warehouses; verify casing exactly matches the Snowflake object.

Need to switch roles or databases fast?

Use DBeaver’s SQL Console: USE ROLE ANALYST; USE DATABASE SALES_DB;. The change is instant and scoped to the current session.

Can you automate exports?

Yes. In the SQL Editor, right-click results ➜ Export Data ➜ CSV/Parquet. Schedule with DBeaver Tasks for recurring pulls.

Why How to Connect Snowflake to DBeaver is important

How to Connect Snowflake to DBeaver Example Usage


-- List last month’s top-selling products
SELECT p.name, SUM(oi.quantity) AS units_sold, SUM(oi.quantity*p.price) AS revenue
FROM OrderItems oi
JOIN Products p  ON p.id = oi.product_id
JOIN Orders   o  ON o.id = oi.order_id
WHERE o.order_date >= DATE_TRUNC('month', CURRENT_DATE)
GROUP BY p.name
ORDER BY revenue DESC
LIMIT 10;

How to Connect Snowflake to DBeaver Syntax


jdbc:snowflake://<account>.snowflakecomputing.com/?warehouse=<WAREHOUSE>&db=<DATABASE>&schema=<SCHEMA>&role=<ROLE>[&authenticator=externalbrowser][&client_session_keep_alive=true]

Example:
jdbc:snowflake://acme.us-east-1.snowflakecomputing.com/?warehouse=ANALYTICS_WH&db=SALES_DB&schema=PUBLIC&role=ANALYST&client_session_keep_alive=true

Parameters:
  <account>        – Snowflake account locator + region.
  warehouse        – Virtual warehouse to execute queries.
  db               – Default database (e.g., SALES_DB).
  schema           – Default schema (e.g., PUBLIC).
  role             – Role with SELECT on tables.
  authenticator    – externalbrowser | snowflake_jwt | oauth.
  client_session_keep_alive – true keeps the TCP session active.

After connecting you can run:
SELECT o.id, o.total_amount, c.email
FROM Orders o
JOIN Customers c ON c.id = o.customer_id
WHERE o.order_date >= CURRENT_DATE - INTERVAL '30 days';

Common Mistakes

Using the full host URL <code>acme.us-east-1.snowflakecomputing.com</code> in both the account field and the JDBC prefix. Double inclusion breaks DNS lookup. Fix: set account=<code>acme</code> and region in the URL only once.
Leaving <code>CLIENT_SESSION_KEEP_ALIVE</code> off for long-running editors causes "connection closed" errors after 4h idle time. Turn the property on or increase network idle timeout.

Frequently Asked Questions (FAQs)

Can I use SSO or Okta with DBeaver?

Yes. Set authenticator=externalbrowser in the JDBC URL. DBeaver will open a browser window for Okta or your IdP. After login, the IDE reuses the issued token.