Step 1: Create
a new Snowflake user for testingSnowflake offers a cloud-based data storage and analytics service (see https://www.snowflake.com/). You can protect access to Snowflake by integrating Snowflake with Identity as a Service. Once integrated, users can use single sign-on to log in to their Snowflake account through Identity as a Service.
Note: This integration was tested using Identity as a Service version 5.13 and Snowflake version 4.42. Other versions of Snowflake may require integration and configuration steps that differ from those documented in this procedure. For other versions of Snowflake, this integration guide may be used as an initial approach for integrating Snowflake. In the event of other issues, contact support@entrust.com for assistance.
If you need assistance configuring Snowflake for Identity as a Service authentication, see https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-idp.html#custom-idp-setup.
Step 1: Create
a new Snowflake user for testingCreate a Snowflake user for testing
Note: If
you need assistance with this section,
see the following Snowflake documentation:
- Create a user: https://docs.snowflake.com/en/user-guide/admin-user-management.html#creating-users
- Create a user without a password: https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-use.html#label-users-fed-auth
1. Log in to your Snowflake system or admin account.
2. Click
next to your user name and select Switch
Role > ACCOUNTADMIN.
The New Worksheet page appears.
3. Click the Account tab. The Account page appears.
4. Click Users. The Users list appears.
5. Click Create. The Create User dialog box appears.
6. In the User Name field, enter a user name for the new user.
7. Enter and confirm a New Password.
8. Deselect Force Password Change.
9. Click Next. The Advanced settings appear.
10. In the Login Name field, enter the user name of the new user.
11. In the Email field, enter the email address of the new user.
12. Click Next. The Preferences settings appear.
13. From the Default Role drop-down list, select ACCOUNTADMIN.
14. Click Finish.
15. Click the Worksheets tab.
16. Ensure
that the Role that appears in the Worksheet metadata is also set to
ACCOUNTADMIN
(
).
Note: The role set at the upper right-hand corner can be different from the role at your worksheet.
17. If you need to change the role, do the following:
a. Click the role. The Role dialog box appears.
b. Click Change and select ACCOUNTADMIN from the drop-down list.
18. From the Set Context drop-down list, select ACCOUNTADMIN. You need to do this step to have privileges to submit the SQL query.
19. In the Worksheet console, enter
alter user <username> set PASSWORD = ''; where <username> is the name is the new user you just created.
20. Click Run and confirm that the operation succeeded. If it does not work, check the SQL syntax and rerun the command.
Step
2: Add Snowflake to Identity as a ServiceAdd Snowflake as an application to Identity as a Service
Before you begin, you need to obtain the following:
● Assertion Consumer Service URL (Single-Sign URL)—See https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-idp.html#step-2-define-claim-rules-for-the-snowflake-relying-party-trust. Snowflake refers to this as the Relying Party Trust.
● Service Provider Entity ID—See https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-idp.html#step-2-define-claim-rules-for-the-snowflake-relying-party-trust. . Snowflake refers to this as the Relying Party Trust Identifier.
● Single Logout Service URL—See https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-idp.html#step-3-enable-global-logout-optional. Snowflake refers to this as the Logout.
1. Log into your Identity as a Service administrator account.
2. Click
> Security > Applications. The Applications
Lists page appears.
3. Click Add. The Select an Application Template page appears.
4. Do one of the following:
● Select SAML Cloud Integrations from the search drop-down list and scroll to find the application you want to add to IDaaS.
- or -
● In the Search bar, enter a search option to filter for the application you want to add to IDaaS.
5. Click Snowflake. The Add Snowflake page appears.
6. Enter an Application Name.
7. Enter an Application Description.
8. Optional. Add a custom application logo.
a. Click 
next to Application Logo. The
Upload Logo dialog box appears.
b. Click 
to
select an image file to upload.
c. Browse to select your file and click Open. The Upload Logo dialog box reappears showing your selected image.
d. If required, resize your image.
e. Click OK.
9. Select the Authentication Flow that appears to users during login.
10. Click Next. The General page appears.
11. In the Default Assertion Consumer Service URL field, enter the URL you obtained from https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-idp.html#step-2-define-claim-rules-for-the-snowflake-relying-party-trust (Relying Party Trust).
Example: https://<account_name>.<region_id>.snowflakecomputing.com/fed/login
12. In the Service Provider Entity ID field, enter the URL you obtained from https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-idp.html#step-2-define-claim-rules-for-the-snowflake-relying-party-trust (Relying Part Trust Identifier).
Example: https://<account_name>.<region_id>.snowflakecomputing.com
13. In the Single Logout Service URL field, enter the URL you obtained in https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-idp.html#step-3-enable-global-logout-optional (Logout).
Example: https://<account_name>.<region_id>.snowflakecomputing.com/fed/logout
14. Optional. Enter the SAML Username Parameter Name used to identity the user ID being requested for authentication. The user ID can then be passed as a parameter, for example, Username=jdoe. Alternately, if the SAML username is NameID, the SAML Request XML NameID element value is used to the identify the IDaaS userID.
15. Enter the SAML Session Timeout to the time when the SAML Assertion times out. The maximum is 720 minutes.
16. Enter the Max Authentication Age (seconds) to set the maximum amount of time that can elapse before a user is required to reauthenticate during a new login attempt. This applies for both SP-initiated and IDP-initiated login. Set this field to -1 to disable this feature.
17. Optional. Enter the SAML Username Parameter Name used to identity the user ID being requested for authentication. The user ID can then be passed as a parameter, for example, Username=jdoe.
18. From the SAML NameID Attribute drop-down list, select User ID.
19. From the SAML NameID Encoding Format drop-down list, select Email.
20. From the SAML Signing Certificate drop-down list, select the signing certificate.
21. From the SAML Signature Algorithm, select SHA256.
22. Select Sign the complete SAML Response.
23. Deselect Enable Go Back Button if you do not want users to be able to go back to the Snowflake login page to log in.
24. Select Show Default Assertion Consumer URL Service in the My Profile. When selected, the Default Assertion Consumer URL appears in a user's My Profile page in addition to relay states and Alternative Assertion Consumer URLs.
25. Optional. Add Alternative Assertion Consumer Service URLs, as follows:
a. Click Add.
b. Enter a Name.
c. Enter a URL Value.
d. Select Show in My Profile to display the Alternative Consumer Service URL in a user's My profile page.
e. Optional. Add an Application Logo.
f. Click Add.
g. Repeat these steps to add more Alternative Assertion Consumer Service URLs.
26. Click Submit.
Step 4: Copy
the SAML Configuration from Identity as a ServiceCopy the SAML Configuration from Identity as a Service
1. Log into your Identity as a Service administrator account.
2. Click
> Security
> Applications. The Applications Lists page appears.
3. Under SAML Cloud Integrations, click SAML Configuration. The SAML Configuration dialog box appears.
This dialog box contains information you need to configure your SAML application for Identity as a Service authentication.
4. Do one of the following:
● Leave this dialog box open to reference later in this procedure.
● Copy the Entity ID, Single Sign-on URL, and Single Logout URL to a text file and save it to reference later in this procedure.
Note: Depending on the integration you are performing, you may not need all three of these SAML configuration values.
Note: You need to copy the Single Sign-On URL. You need this URL in Step 6: Configure Snowflake for Identity as a Service authentication.
Step
5: Export the signing certificate from Identity as a ServiceExport a SAML signing certificate
1. Log in to your Identity as a Service administrator account.
1. Click
> Security > Applications.
The Applications List page appears.
2. Under SAML Cloud Integrations, click SAML Signing Certificates. The SAML Signing Certificates page appears.
3. Click
next to the certificate to export the certificate
you want to import into your SAML service provider application. The Export Certificate dialog box appears.
a. If the certificate has been issued by a CA, do one of the following:
– Click Certificate to export the self-signed certificate.
– Click Root CA Certificate to export a certificate issued from a CA.
– Click Certificate Chain to export the SAML signing certificate and its CA certificates.
b. Click Export.
Step 6: Configure
Snowflake for Identity as a Service authenticationConfigure Snowflake for Identity as a Service authentication
For assistance with this section, see https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-configure-snowflake.html#step-2-specify-idp-information-for-snowflake. To complete this step, you need to issue SQL queries.
1. Log in to your Snowflake account.
2. Click
next to your user name and select Switch
Role > ACCOUNTADMIN. The New
Worksheet page appears.
3. Click the Worksheets tab.
4. From the Set Context drop-down list, select ACCOUNTADMIN. You need to do this step to have privileges to submit the SQL query.
5. In the Worksheet console, construct the SQL query like the following:
use role accountadmin;
alter account set saml_identity_provider = '{
"certificate": "",
"ssoUrl": "",
"type" : "Custom",
"label" : ""
}';
6. Open the certificate you copied in Step 4: Export the signing certificate from Identity as a Service with a text editor, such as Notepad.
7. Copy the contents of the certificate, excluding "=====BEGIN CERTIFICATE=====" and "=====END CERTIFICATE=====" and paste into the certificate in the Worksheet.
Attention: You need to remove all the line breaks to make it one long string.
Example: "certificate": "insert certificate here as one long string",
8. Copy the Single Sign-On URL you copied in Step 4: Copy the SAML Configuration from Identity as a Service and paste into the ssoURL in the Worksheet.
Example: "ssoURL": "https://<my_tenant>.us.trustedauthdev.com/api/saml",
9. The "label" is the button name that appears on the Snowflake Login page for Single Sign-On. Add a user-friendly name without special characters.
Example: "label": "Entrust",
10. Click Run and confirm that the operation succeeded. If it does not, check the SQL syntax and rerun the command.
11. Clear the Worksheets so that it is blank again.
12. On the Worksheet, construct the SQL query like the following:
use role accountadmin;
alter account set sso_login_page = true;
13. Click Run and confirm that the operation succeeded. If it does not, check the SQL syntax and rerun the command.
Step 7: Test
the integrationTesting Service Provider Login
1. Open a Web browser and enter the URL for your Snowflake account. You are directed to Identity as a Service.
2. Enter your Snowflake account User ID and click Next.
3. Respond to the second-factor authentication challenge. If you respond successfully, you are logged in to the Snowflake.
Testing Identity as a Service redirect log in
1. Log in to your Identity as a Service account.
2. Go to your My Profile page if you are not already there.
3. Under Applications, click Snowflake.
4. Respond to the second-factor authentication challenge. If you respond successfully, you are logged into Snowflake.