Snowflake
Snowflake is a relational ANSI SQL data warehouse in the cloud. Due to its unique architecture designed for the cloud, Snowflake offers a data warehouse that is faster, easier to use, and far more flexible than traditional data warehouses.
Authorization
OAuth2
To use the OAuth 2.0 authentication type for a Snowflake connection, you must first create a set of client id and secrets. To do so, you will need to create a custom integration record.
After successfully creating this integration record, you can retrieve the client id and secret using this SQL command:
SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('WORKATO_OAUTH');
The redirect URI, which is the URI that Snowflake redirects the user to after they perform authorization with a short-lived authorization code.
The client type. Snowflake supports both confidential and public clients. Confidential clients are those that maintain secrets, whereas public clients cannot. Each client type has different behavior with respect to authorizations; the key difference is that confidential clients will not prompt the user to authorize a role if a previous authorization exists, whereas a public client will always prompt for authorization.
When you create your Snowflake app, you must be sure to enter Sapper's OAuth callback URL -Sapper.
Refer to the Snowflake documentation for more information.
Snowflake Connection
Snowflake OAuth2.0 Connection
Input | Key | Description | Example |
Select application | application | Select Snowflake application |
|
Connection type | connection type | Select the type of connection. | REST |
REST connection type | rest connection type | Select the type of REST connection. | OAuth2.0 |
Connection name | name | Provide a name for the connection. | Snowflake connection |
Connection description | description | Provide a description for the connection. |
|
Host name | host | Provide a string value for the URL of user's Snowflake account. |
|
Grant type | grant type | Provide the grant type - Authorization code, Password, Client Credentials. |
|