Datalore 2023.6 Help

Snowflake

This is a general procedure of creating a Snowflake database connection. Follow these instructions to use the interface of the New connection dialog for this particular database type.

Configure an Snowflake 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

    • Go to Main menu | Tools | Attached data or click the Attached data icon on the left-hand sidebar.

    • Click New connection and select New database connection.

    • In the New database connection dialog, select Snowflake.

    • On the Home page, select the workspace where you want to create the connection.

      Selecting a workspace
    • Select Databases from the menu under the workspace name.

    • Click the Add connection button in the upper right corner. The New database connection dialog will open.

    • 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.

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

  4. (For default) In the Port field, type the port of BigQuery. The default port is 443.

  5. Select an authentication method:

    • 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.

    • 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.

    • No auth: to connect without authentication.

  6. Proceed based on the selected authentication method:

    UserPassword

    1. In the User and Password, provide your credentials.

    2. In the Authenticator, provide the authenticator.

    Get a client ID and a client secret by following the official instructions. Proceed by doing the following in the New Snowflake connection dialog:

    1. In the Client ID field, paste your client ID.

    2. In the Client secret field, paste your client secret.

    Get a client ID, client secret, and access and refresh tokens by following the official instructions. Proceed by doing the following in the New Snowflake connection dialog:

    1. In the Client ID field, paste your client ID.

    2. In the Client secret field, paste your client secret.

    3. Click Authenticate and fill tokens.

    If you don't have a working Okta integration, refer to Snowflake official docs and this article to configure Okta as your IdP with Snowflake.Proceed by doing the following in the New Snowflake connection dialog:

    1. In the Client ID field, paste your client ID.

    2. In the Client secret field, paste your client secret.

    3. In the Okta Issuer URL, paste the string containing the EntityID / Issuer for the Snowflake service provider.

    No special steps are required for this option.

  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, provide the database role.

    URL

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

  9. Once the connection is successfully tested, click the Save 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 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 noteboook 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.

Last modified: 24 November 2023