Connection reference for Snowflake
Here is a list of the fields of a Snowflake connection. You need specific information to establish a seamless and secure connection. All fields are required, except where noted.
- Connection name
-
Enter a new Snowflake connection name.
- Connection description
-
Provide a short description of the connection. (Optional)
- Account name
-
Enter the account name associated with your Snowflake connection. The account name is part of the URL that you use to access the Snowflake UI. It is the portion of the URL before
snowflakecomputing.com.
Example: If your URL ishttps://abcd.xyz.efg.snowflakecomputing.com, your account name isabcd.xyz.efg.
Assume that the account name is xy12345.
| Cloud platform | Region | Full account name |
|---|---|---|
AWS |
US East (N. Virginia) |
xy12345.us-east-1 |
US East (Ohio) |
xy12345.us-east-2.aws |
|
US West (Oregon) |
xy12345 |
|
Canada (Central) |
xy12345.ca-central-1.aws |
|
EU (Ireland) |
xy12345.eu-west-1 |
|
EU (Frankfurt) |
xy12345.eu-central-1 |
|
Asia Pacific (Singapore) |
xy12345.ap-southeast-1 |
|
Asia Pacific (Sydney) |
xy12345.ap-sowtheast-2 |
|
GCP - Preview |
us-central1 (Iowa) |
xy12345.us-central1.gcp |
Azure |
East US 2 |
xy12345.east-us-2.azure |
US Gov Virginia |
xy12345.us-gov-virginia.azure |
|
Canada Central |
xy12345.canada-central.azure |
|
West Europe |
xy12345.west-europe.azure |
|
Australia East |
xy12345.australia-east.azure |
- User
-
Enter the Snowflake account username.
- Password
-
Enter the Snowflake account password.
- Role
-
Specify the privilege of the user.
- Warehouse
-
Specify the warehouse associated with the connection.
- Database
-
Specify the database associated with the account. (Optional)
- Schema
-
Specify the schema associated with the database.
- OAuth
-
Enter the OAuth client ID associated with the Snowflake database.
- OAuth client secret
-
Enter the OAuth client secret associated with the Snowflake database.
- Scope
-
(Azure AD OAuth) Enter the scope associated with your Azure AD OAuth.
Scope maps to a role in your Snowflake database.
It should be similar to
session:role:developer offline_access.
- Auth Url
-
(Azure AD OAuth) Enter the Auth URL associated with your Azure AD OAuth.
ThoughtSpot performs an "Authorization Code" grant type flow to get the access token. Get the authorization endpoint for Azure AD OAuth app from Azure portal. It should be similar to https://login.microsoftonline.com/<tenant_id>/oauth2/v2.0/authorize.
- Access Token Url
-
(Azure AD OAuth) Enter the Access Token Url associated with your Azure AD OAuth.
Token endpoint can be obtained from the Azure portal by navigating to the OAuth application in Azure Active Directory resource. It should be similar to https://login.microsoftonline.com/<tenant_id>/oauth2/v2.0/token.
Related information
