Snowflake

Last modified: 12 March 2025

This procedure explains how to configure a Snowflake database connection.

Configure a Snowflake database connection

  1. Open the New Snowflake connection dialog. Select the tab for one of the two options:

    • From the editor, to attach the new database to a specific notebook

    • From the Home page, to add a database connection to a workspace

    1. Open the Attached data tool from the left-hand sidebar.

    2. Switch to the Databases tab. You will see the list of all database connections available from the respective workspace.

    3. At the bottom of the tab, click New database.

      Creating connection from notebook

    4. In the New database connection dialog, select Snowflake.

  2. On the General tab, select the connection type.

    • default: to connect by specifying the Host, Port, and Database.

    • URL only: to connect by providing the URL of a pre-built connection.

      note

      Use this method to pass additional parameters. For example, add &SSL=true to the URL string to enable SSL.

  3. (For default) In the Host field, type your Snowflake instance address.

  4. (For default) In the Port field, type 443.

  5. Select an authentication method:

    warning

    Deprecation notice: User & Password authentication method is in the deprecation phase. We advise against using it, as this might cause issues with your connection in the future.

    For more information, see an official Snowflake blog.

    • User & Password: to connect using your login and password.

    • Authenticator: to connect using the authenticator to verify the user login credentials. For example, to use browser-based SSO for authentication, enter externalbrowser.

      For more information about the authenticator, refer to the Snowflake official documentation.

    • Key pair: to connect using the private RSA key stored in Datalore.

      note

      Passphrase-protected key pairs are currently not supported.

    • Snowflake OAuth: to connect using the Snowflake OAuth method.

    • Snowflake with stored tokens: to connect using access and refresh tokens.

    • Snowflake Okta OAuth: to connect using Okta integration.

    • Snowflake Azure OAuth: to connect using Azure OAuth2 integration.

    • No auth: to connect without authentication.

  6. Proceed based on the selected authentication method:

    In the User and Password, provide your credentials.

  7. Based on the selected connection type, do the following:

    • In the Database field, provide the name of the database you want to connect to.

    • (Optional) In the Schema field, provide the schema you want to access.

    • (Optional) In the Warehouse field, type the name of a cluster of compute resources in Snowflake you want to use. For more information about warehouses, refer to the Snowflake official documentation.

    • (Optional) In the Role field, provide the database role.

  8. (Optional) For other options (SSH tunneling, scope inspection, or additional connection parameters), switch to the respective tab of the dialog and follow one of these procedures.

  9. Click the Test connection button at the bottom of the dialog.

  10. Once the connection is successfully tested, click the Create and close button.

Results

  • If created for a specific notebook, the new connection will be automatically added to the workspace. You can later attach this database connection to any other notebook from this workspace.

  • If created for a workspace, this connection is added to the workspace databases and can be attached to any notebook from this workspace.

  • If OAuth authentication was used for this connection, report users and notebook collaborators may be required to provide their credentials to access the database.

  • To retrieve and process data from the connected database, use Query data with SQL cells.