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
- 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)
Select the MANAGE GRANTS (H) privilege and click on Update Privileges. - 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.
- In the new worksheet, paste the below queries and click on the play icon.
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
- 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.
- 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
- Add the last commend
GRANT ALL ON INTEGRATION TORII to SYSADMIN
- and click the play icon
- From Worksheet, Click on + Worksheet.
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:
- Go to Torii's Integrations page and click the Snowflake tile
- Click Connect
- In the Connect Snowflake window, enter the Client ID & Client Secret
- Enter the Base Url
- Click Continue
- The "Test Connection" window will display, generating the connection test.
Click Connect to continue. -
Once the integration is connected and synced, it will display a green checkbox.