Appearance
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, withouthttps://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
- In Snowflake's web interface (Snowsight), open the account selector showing your current account.
- Select View account details and copy the Account/Server URL.
- Remove
https://,.snowflakecomputing.com, and any trailing slash. For example,https://myorg-myaccount.snowflakecomputing.combecomesmyorg-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.
