Skip to content

Connect to Snowflake ​

To get set up with Snowflake, you'll need to provide the following information in the Supersimple connection setup page:

  • Account Identifier: Your organization and account name separated by a hyphen, such as myorg-myaccount. Enter only the identifier, without https:// or .snowflakecomputing.com.
  • Database Name: The name of the database you want to connect to
  • Username: Your Snowflake username
  • Warehouse: The name of the Snowflake warehouse to use for queries
  • Role: The Snowflake role to use for the connection

We recommend creating a dedicated read-only user and role for Supersimple.

Find your account identifier ​

  1. In Snowflake's web interface (Snowsight), open the account selector showing your current account.
  2. Select View account details and copy the Account/Server URL.
  3. Remove https://, .snowflakecomputing.com, and any trailing slash. For example, https://myorg-myaccount.snowflakecomputing.com becomes myorg-myaccount.

Alternatively, run this query in a Snowflake SQL worksheet and copy the result into Account Identifier:

sql
SELECT CURRENT_ORGANIZATION_NAME() || '-' || CURRENT_ACCOUNT_NAME();

See Snowflake's account identifier guide for more details.

Choose an authentication method ​

  • Key pair (default): Paste an unencrypted PKCS#8 private key in PEM format into Private key. The matching public key must be assigned to the Snowflake user. See Snowflake's key-pair setup guide.
  • Password: Select Password under Authentication method and enter the password for your Snowflake user.