Skip to content
English
  • There are no suggestions because the search field is empty.

Connecting to Snowflake from a SQL client app

This guide will walk you through connecting to Snowflake using DBeaver Community Edition. While this guide is specific to DBeaver Community Edition, the steps are very similar for other SQL clients, including the paid versions of DBeaver.

Snowflake has detailed documentation on how to integrate database systems in Snowflake: Snowflake Connectors.

Step 1: Install and Open DBeaver Community Edition

  1. Download and install DBeaver Community Edition from DBeaver’s official site.

  2. Launch DBeaver on your machine.

Step 2: Create a New Connection

  1. In the DBeaver main window, click the New Database Connection button (a plug icon) or navigate to Database » New Database Connection.

  2. In the Connect to Database wizard, search for and select Snowflake, then click Next.

Step 3: Enter Connection Details

  1. Fill in the required fields for your Snowflake account:

    • Host: Enter your Snowflake account URL, typically formatted as account-name.snowflakecomputing.com. Example: yourcompany.snowflakecomputing.com

    • Database: Specify the default database to connect to (this can be changed later).

    • Warehouse: Enter the name of the Snowflake warehouse you want to use.

    • Schema: Optional—leave blank to access all schemas in the selected database.

      DBeaver connection

  2. Under Authentication, select Username and Password or External Browser (SSO):

    • For SSO:

      • Select External Browser.

      • When prompted after clicking Test Connection, complete the SSO login in your web browser. (Follow the steps in Login to a Snowflake Reader Account).

    • For Username and Password:

      • Enter your Snowflake username (usually your email) and password.

  3. (Optional) Click Driver Properties to modify advanced settings, if required.

  4. Click Test Connection to verify the configuration.

  5. If successful, click Finish to save the connection.

Step 4: Access Your Snowflake Data

  1. In the DBeaver Database Navigator panel, expand your new Snowflake connection to browse databases, schemas, and tables.

  2. Double-click a table to preview its data or start writing SQL queries in the SQL Editor by right-clicking the connection and selecting SQL Editor.

Step 5: Querying Data

  1. Open a new SQL Editor tab by right-clicking your connection in the Database Navigator and selecting SQL Editor » New SQL Script.

  2. Write your SQL query. For example:

SELECT * FROM your_database.your_schema.your_table LIMIT 10;

  1. Click the Execute SQL Statement button (an orange play icon) or press Ctrl+Enter / Cmd+Enter to run the query.

  2. View the results in the Results Pane below the editor.

Step 6: Export Query Results

  1. After executing your query, right-click anywhere in the Results Pane and select Export Data.

  2. Choose your desired file format (e.g., CSV, Excel).

  3. Follow the prompts to specify the file location and export settings, then click Finish.


Tips & Troubleshooting

  • SSO Login Issues: Ensure your Snowflake account is configured for Single Sign-On and that you’re using the correct host URL.

  • Performance: If queries are slow, check the configured warehouse and consider increasing its size.

  • Connection Errors: Double-check your connection details, especially the host URL and authentication method.

  • Query Optimization: Use LIMIT clauses and narrow down results with WHERE conditions to improve performance for large datasets.

For additional information, refer to Snowflake Connectors Documentation.