How can we help?

Snowflake Integration

Noga Tubi
Noga Tubi
  • Updated

Overview

  • Torii integrates with Snowflake and syncs the Users' data: email, first name, last name, role, status, license status, creation time in-app, and last visit time.
  • Torii can support multiple Snowflake accounts.

Prerequisites

  • You need to be a Snowflake ACCOUNTADMIN
    mceclip0.png
  • You will need the following permission to connect the integration SYSADMIN > MANAGE GRANTS.
    Go to Users & Roles (A) >> Roles (B) >> SYSADMIN (C) >> Manage global privileges (D)
    mceclip11.png
    Select the MANAGE GRANTS (H) privilege and click on Update Privileges.
    mceclip12.png

  • Open and configure a new worksheet to create the Base URL, Client ID and Key with which you will be able to connect to Torii 
    • From Worksheet, Click on + Worksheet. 
      mceclip1.png
    • In the new worksheet, paste the below queries and click on the play icon.
      image (20).png
      create or replace security integration TORII
      type = oauth
      enabled = true
      oauth_client = custom
      oauth_client_type = 'CONFIDENTIAL'
      oauth_redirect_uri = 'https://api.toriihq.com/api/auth/snowflake/callback'
    • Every 90 days, you will need to reconnect the integration and do this authorization flow
      again to obtain a new refresh token since the max is 90 days
    • Ensure that the integration is successful
      image (21).png
    • To get the Base URL, add
      DESCRIBE SECURITY INTEGRATION TORII; 
    • and click the play icon.
    • Base URL - Go to OAUTH_AUTHORIZATION_ENDPOINT and COPY the address up to the - com. as this will be required when connecting the integration.
      mceclip1.png
    • To get the Client ID and Client Secret, paste the following;
      select system$show_oauth_client_secrets('TORII');
    • and click the play icon.
    • Scroll down, Copy, and save the Client Secret and Client ID
      mceclip0.png
    • Add the last commend
      GRANT ALL ON INTEGRATION TORII to SYSADMIN
    • and click the play icon
      mceclip10.png

Integration Process

To connect Snowflake to Torii, Ensure that the person who connects the app will have the default role: SYSADMIN, then follow these steps:

  1. Go to Torii's Integrations page and click the Snowflake tile
  2. Click Connect
  3. In the Connect Snowflake window, enter the Client ID & Client Secret
  4. Enter the Base Url
  5. Click Continue
    mceclip0.png
  6. The "Test Connection" window will display, generating the connection test.
    Click Connect to continue.
    mceclip1.png
  7. Once the integration is connected and synced, it will display a green checkbox.

     
     

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request