1. Documentation
  2. Database Compare Suite
  3. Connecting to a Snowflake database
Database Compare Suite™

Connecting to a Snowflake database

Use the following procedure to connect to your Snowflake database.

  1. Click the New icon in the Project panel at the top left corner of the window.

  2. Select Snowflake in the Platform drop-down list at the top of the dialog box.

    Connect to Snowflake data warehouse

  3. Select the Standard option in the Mode drop-down list if you would like to connect to your Snowflake database in the standard mode.

    connecting to a snowflake database standard mode

    • Specify the Account name in the drop-down list. You can enter it manually or select it from the drop-down list (if it has been already used).
    • Specify the Host URL in the appropriate field. You can use a global URL here or leave this field empty.
    • Provide the rest of connection information to the Snowflake database: the Warehouse name and the Database name. You can enter these values manually or select them from drop-down lists.
    • Enter the Username and Password to complete the information about the Snowflake connection.
    • Press the Test button to verify that you can successfully connect to your Snowflake data warehouse.

  4. Select the ConnectionString option in the Mode drop-down list if you would like to connect to the Snowflake database, using the connection string.

    connecting to a snowflake database connection string

    • Enter the Connection string manually or select from the drop-down list (if it has been already used).

    • Find the connection string template below. Use it as an example to create a connection string that allows to connect to your Snowflake database:

      account=sf_account;db=SNOWFLAKE_DB;warehouse=SNOWFLAKE_WH;user=sf_user;password=pass

    • Use the following connection string template to create a connection string that allows to connect to your Snowflake database with the host name specified:

      account=sf_account;host=sf_account.snowflakecomputing.com;db=SNOWFLAKE_DB;warehouse=SNOWFLAKE_WH;user=sf_user;password=pass
    • Press the Test button to verify that you can successfully connect to your Snowflake database.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email product-support@dbbest.com.