Snowflake
Snowflake is a cloud-based data warehousing platform that enables users to store and analyze large volumes of data. It provides a scalable and flexible solution for data storage and analytics.
You must have an admin account in Snowflake.
1 Go to Dashboard > Marketplace > SSO Integrations.
2 Select Snowflake from the list.
3 You'll land on the overview page, with an additional tab: Installation (providing a step-by-step installation guide).
4 Click on INSTALL.
5 Provide a Name, and for the Entity ID, go to your Snowflake admin console.
6 Click on the Snowflake ID.
7 Click on the first group.
8 Copy the account URL, this is your Entity ID.
Make sure the Locator ID part of the URL has the same case definition as the Locator ID.
9 Return to your dashboard, paste the Entity ID.
10 For ACS URL, paste the same above copied URL. Ensure to add /fed/login to the end of the URL.
11 Once the configurations are provided, click on INSTALL.
12 Switch to Snowflake, click on Worksheet > + Worksheet.
13 A new worksheet will be displayed. Use the followiing code block in your worksheet, get all the necessary configs from your dashboard.
use role accountadmin;
alter account set saml_identity_provider ='{
"certificate": "-----certificate from your dashbaord------",
"ssoUrl" : "-- single sign on url from your dashbaord",
"type": "custom",
"label" : "---------name as per your requirements---------"}';
use role accountadmin;
alter account set sso_login_page = true;
14 Return to your dashboard, go to Applications > SSO, and click on the created Snowflake SSO.
18 Click on Metadata, where the list of endpoints for the particular SSO will be available. Copy the X509 certificate.
Make sure not to copy BEGIN CERTIFICATE and END CERTIFICATE.
19 Switch to Snowflake, paste the copied certificate.
20 Return to your dashboard, copy the Login Endpoint.
21 Switch to Snowflake, paste the Login Endpoint in SSO URL.
22 Provide any name in the label field.
23 Click on Run.
24 Statement will be successfully executed.
25 Click on the back icon.
26 Click on Admin > Users & Roles.
27 Click on + User.
28 Provide the Username and Email.
- The Email and Username should match with the user's Email and Username in your dashboard.
- If you are giving Email as your Username. Make sure it is inside quotation.
Example:
xxxxxx@gmail.com
29 Provide Password.
30 Click on Create User.
31 User will be created in Snowflake. Click on the option button of your created user.
32 Click on Edit from the option.
33 Click on Default Role, and choose the role you wish to assign to the particular user from the drop-down. Click on Save User.
34 Return to your dashboard, assign a user with Snowflake role. To do so, navigate to Users or Workspace Admins, click on the user you want to assign the role.
35 You will be taken to the user's Details tab, click on Roles & Groups.
36 Select List View and click on + ADD ROLE.
37 The available roles will appear; select sso-Snowflake-Snowflake-role and click on ADD ROLES.
38 To verify whether SSO has been successfully enabled, go to Applications > SSO, click on SSO DASHBOARD button.
39 The Snowflake SSO will be enabled successfully.
