Prepare Snowflake credentials

In order to retrieve required credentials, please follow the below steps

1. Sign in to Snowflake

2. Perform below step detail to connect Snowflake to Anduin:

   • a. Create new worksheet , then run the code below. You can rename the INTEGRATION_DEMO to what you want. The pre_authorized_roles_list specifies which role can be used for this integration. You can read our detailed guide on role & permission to decide which values to enter here.
     JSX

     create security integration INTEGRATION_DEMO
         type = oauth
         oauth_client = custom
         oauth_client_type = 'public'
         oauth_redirect_uri = 'https://oauth2.integration-platform.anduin.app/callback'
         enabled = true
         pre_authorized_roles_list = ( 'USERADMIN','SYSADMIN')
         oauth_issue_refresh_tokens = true
         oauth_refresh_token_validity = 864000
     

   • b. Then run below and use Authorize URL, Token URL and Client ID for the config
     JSX

     DESCRIBE INTEGRATION INTEGRATION_DEMO
     

   • c. Run this code to get Client Secret to finish the config
     JSX

     SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('INTEGRATION_DEMO')
     

   • d. Get Snowflake Identifier URL by the code below **and replace the result to <identifier-result> **to finish url https://<identifier-result>.snowflakecomputing.com
   JSX

   SELECT CURRENT_ORGANIZATION_NAME() || '-' || CURRENT_ACCOUNT_NAME();
   

   • e. Get Snowflake Account Locator, using the prefix from Authorize URL
   
   

3. Create warehouse, database

   • a. Create warehouse SQL
     JSX

     CREATE WAREHOUSE ANDUIN_WH
       WITH WAREHOUSE_SIZE = 'X-SMALL'
       AUTO_SUSPEND = 300
       AUTO_RESUME = TRUE
       INITIALLY_SUSPENDED = TRUE;
     

   • b. Create database SQL
     JSX

     CREATE DATABASE IDM_DB;
     

   • c. Input ANDUIN_WH to Warehouse and IDM_DB to Database in the configuration wizard