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
      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
      DESCRIBE INTEGRATION INTEGRATION_DEMO
      
    • c. Run this code to get Client Secret to finish the config
      SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('INTEGRATION_DEMO')
      
    • d. Change default role to SYSADMIN

    • e. Get Snowflake Identifier URL by the code below **and replace the result to <identifier-result> **to finish url https://<identifier-result>.snowflakecomputing.com
      SELECT CURRENT_ORGANIZATION_NAME() || '-' || CURRENT_ACCOUNT_NAME();
      
    • f. Get Snowflake Account Locator, using the prefix from Authorize URL

  3. Create warehouse, database

    • a. Create warehouse SQL
      CREATE WAREHOUSE ANDUIN_WH
        WITH WAREHOUSE_SIZE = 'X-SMALL'
        AUTO_SUSPEND = 300
        AUTO_RESUME = TRUE
        INITIALLY_SUSPENDED = TRUE;
      
    • b. Create database SQL
      CREATE DATABASE IDM_DB;
      
    • c. Input ANDUIN_WH to Warehouse and IDM_DB to Database in the configuration wizard