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 codes in the worksheet and execute them.

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;

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 in the worksheet to generate  and execute it. 

select SYSTEM$SHOW_OAUTH_CLIENT_SECRETS( 'MY_SNOWSQL_CLIENT_JOSYS' );

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.