Skip to main content

Snowflake Integration

Integrating Snowflake with Josys lets the IT Admin view and manage user accounts.   

Key benefits

When you integrate Josys with Snowflake, you can: 

  • View: List of user accounts, including their status, roles, and timestamps for the user account creation and last login activity.
  • Perform Action: Add and delete user accounts.

Note: Josys supports multiple Snowflake integrations.


Prerequisites

Before you begin with the integration, make sure that you have:

  • A Snowflake admin account
  • A Client ID, Client Secret, Authorization Endpoint, Token Endpoint, and Account Identifiers.
  • A Standard, Enterprise, Business Critical, or Virtual Private Snowflake plan

Generating Client ID, Authorization Endpoint, and Token Endpoint  

Step 1: Log in to Snowflake using an account with admin privileges.

Step 2: Click Create and select SQL Worksheet on the left. 

Step 3: Copy the following code in the worksheet and execute it.

CREATE SECURITY INTEGRATION MY_SNOWSQL_CLIENT_JOSYS
TYPE = OAUTH
ENABLED = TRUE
OAUTH_CLIENT = CUSTOM
OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
OAUTH_REDIRECT_URI = 'https://app.josys.it/admin/integrations/callback/snowflake'
OAUTH_ISSUE_REFRESH_TOKENS = TRUE
OAUTH_REFRESH_TOKEN_VALIDITY = 7776000
;
 

alter account set OAUTH_ADD_PRIVILEGED_ROLES_TO_BLOCKED_LIST = false;
 

Step 4: Copy the following code in the worksheet and execute it to generate the Client ID, Authorization Endpoint, and Token Endpoint.

DESC SECURITY INTEGRATION MY_SNOWSQL_CLIENT_JOSYS
 

Step 5: Copy the Client ID, Authorization Endpoint, and Token Endpoint to use later in the integration steps.

Step 6: Copy the following code into the worksheet to generate and execute it.

select SYSTEM$SHOW_OAUTH_CLIENT_SECRETS( 'MY_SNOWSQL_CLIENT_JOSYS' );
 

Step 7: Copy the Client Secret to use later in the integration steps. 

Locating the Account Identifier   

Step 1: Log in to Snowflake using an account with admin privileges.

Step 2: Navigate to the User Profile at the bottom left, select Account, and click View account details. 

Step 3: Click the Account Identifier to use later in the integration steps.

Steps to Integrate

Step 1: Select Snowflake from the App Catalog in the Apps section.

Step 2: Provide a suitable Label in the respective field. 

Step 3: Enter the Client ID, Client Secret, Authorization Endpoint, Token Endpoint, and Account Identifiers in their respective fields.

Step 4: Click Next to proceed.

Step 5:  Log in to Snowflake using an admin account. Follow the guided steps to authorize Josys and complete the integration.

Step 6: After the integration is complete, allow some time for data synchronization. You can now view and perform required actions from the Managed Apps in the Apps section.

 

Related articles