Snowflake

This guide will show you how to set up the integration between Snowflake and Clarity Security.

Estimated time to complete: 10 minutes.

Configuring in your Downstream Application

Step 1: Enable OAuth within Snowflake

Within Snowflake, within the left navbar, choose "Projects -> Worksheets", then on the dropdown arrow in the top left of the window to create a new "SQL Worksheet". Once the new worksheet is opened, copy/paste the following command with the redirect URL from step 1 added:

CREATE OR REPLACE SECURITY INTEGRATION oauth_clarity_security
  TYPE = OAUTH
  OAUTH_CLIENT = CUSTOM
  OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
  OAUTH_REDIRECT_URI = '<paste the redirect url from step 1 here>'
  ENABLED = TRUE
  OAUTH_ALLOW_NON_TLS_REDIRECT_URI = FALSE
  OAUTH_USE_SECONDARY_ROLES = IMPLICIT
  OAUTH_ISSUE_REFRESH_TOKENS = TRUE;

Step 2: Get the OAuth Client ID and Client Secret

Next copy/paste the following command to get the OAuth Client ID and Client Secret:

SELECT system$show_oauth_client_secrets('OAUTH_CLARITY_SECURITY');

Please note that the response from that command will be a JSON string with the format:

{
  "OAUTH_CLIENT_SECRET_2": "abc123=",
 "OAUTH_CLIENT_SECRET": "abc124",
  "OAUTH_CLIENT_ID": "foobar"
}

Only use the values from OAUTH_CLIENT_ID and OAUTH_CLIENT_SECRET when setting up the application with Clarity

Step 3: Get the Snowflake Account URL

Within Snowflake, within the left navbar, choose "Admin -> Accounts". Once the Accounts page is open, hover the mouse pointer above the account you'd like to sync with. A small circle icon with an "i" will appear. Hovering over that will provide the "Current URL" that you can copy/paste into the Clarity onboarding form.

Configuring the Integration within Clarity

Step 4: Login to your Clarity Security tenant

https://your-tenant.claritysecurity.io/

Step 5: Click on Applications, then Marketplace

Step 6: Find Snowflake

Scroll to or search for Snowflake in the list of applications from the marketplace, then click Connect.

Step 7: Connect App

Complete the Connect App form.  Details for fields common to all applications can be found at the following article: Common App Configuration Steps

Step 8: App Settings

Complete the App Settings form.  Details for each field can be found at the following article: Common App Configuration Steps

Step 9: User Settings

Complete the User Settings form.  Details for each field can be found at the following article: Common App Configuration Steps

Step 10: Validate Your Selections and Save

Validate the selections from Configure App Step 3, and hit the Save button.

Need Help?