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. Under SAML Cloud Integrations, click Snowflake. The Add Snowflake page appears.
5. Enter an Application Name.
6. Enter an Application Description.
7. 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.
8. Select the Authentication Flow that appears to users during login.
9. Click Next. The General page appears.
10. 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
11. 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
12. 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
13. 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.
14. Enter the SAML Session Timeout to the time when the SAML Assertion times out. The maximum is 720 minutes.
15. 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.
16. 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.
17. From the SAML NameID Attribute drop-down list, select User ID.
18. From the SAML NameID Encoding Format drop-down list, select Email.
19. From the SAML Signing Certificate drop-down list, select the signing certificate.
20. From the SAML Signature Algorithm, select SHA256.
21. Select Sign the complete SAML Response.
22. 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.
23. 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.
24. 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.
25. Click Submit.
Step
3: Create a resource rule to protect access to Snowflake
Create a resource rule to protect access to a SAML application
1. Log in to your Identity as a Service administrator account.
2. Click
> Security
> Resource Rules. The Resource Rules List
page appears.
3. Click + next to the application you want to protect with a resource rule. The Add Resource Rules page appears.
4. Enter a Rule Name and Rule Description for the resource rule.
5. In the Groups list, select the group or groups of users restricted by the resource rule.
These are the groups to which the resource rule applies. If you do not select any groups, by default the resource rule applies to all groups.
6. Click Next. The Authentication Conditions Settings page appears.
7. Optional: Select Disable Single Sign-On for Application to force a user to re-authenticate whenever they attempt a new login.
8. If you do not Enable Advanced Risk Factors, do the following:
a. Select the Authentication Flow from the drop-down list. The Authentication Flow flowchart updates based on the selection.
b. Click Submit to save the Resource Rule.
9. If you want to Enable Advanced Risk Factors, complete the remaining steps in this procedure.
10. Select Enable Advanced Risk Factors to add additional risk factors to the resource rule.
11. Select Enable Strict Access for Application to set the resource rule to deny access regardless of the outcome from other resource rules. If this option is disabled for any resource rule that denies access, the user is allowed access if at least one resource rule allows access.
12. For each Advanced Risk Factor, click the Deny option to deny access to the application if the risk factor fails regardless of the results of the other risk factors.
13. Click Date/Time to set the conditions as follows:
a. Select one of the following:
– Allow Date/Time to set when a user can access the application.
– Deny Date/Time to set when the user cannot access the application.
The Date/Time Context Condition Settings appear.
b. Select the Condition Type:
– Specific Date Range Condition—Allows or denies access to the application during a select period of days.
– Time-of-day and/or Day of Week Recurring Conditions—Allows or denies access to the application on a specific time of day, day of the week, or both. Recurring times selected only apply to days not denied.
– Clear Selection—Clears existing Date and Time conditions.
c. Set the Condition Type settings, as follows:
i) Select Use local time zone to use the local time zone or deselect Use local time zone to use the local time zone and begin typing the time zone in the Begin Typing Timezone name field and select the time zone from the drop-down list.
ii) If you selected Specific Date Range Condition, click Start Date to select a start date from the pop-up calendar. Optionally, select the End Date.
iii) If you selected Time-of-Day and/or Day-of-Week, click Start Time and select the start time from the pop-up clock. Optionally set the End Time. You must also select the days of the week for the condition.
d. Click Save to return to the Authentication Conditions Settings page.
14. Click Geolocation to set the Location Condition Settings, as follows:
a. Select Allow or Deny to create an allowed or denied country list.
b. From the Selected Countries drop-down list, select the countries to add or deny access to the application. Repeat until you have added all the desired countries to the list.
c. Select Allow Anonymous IP Address to increase the risk of users authenticating from an anonymous IP.
d. Click Save to save to return to the Authentication Conditions Settings page.
15. Click Source IP Address. The IP Address Risk Setting dialog box appears. Do one of the following:
a. Select Custom and add the required IP Allowed Addresses and IP Denied Addresses.
b. Select IP List Address and select the IP List to allow or deny.
c. Select None to not restrict any IP addresses.
d. Click OK to return to the Authentication Conditions Settings.
16. Click Machine Authentication to set the Machine Authentication Condition Settings, as follows:
a. Set the Machine Authentication Risk is less than or equal to the value that the machine authenticator's total risk score must be less than during authentication to pass this condition.
The risk score is based on the attribute differences
between a user's Machine Authentication information and that recorded
on Identity as a Service before the condition fails. If an attribute does
not match, the attribute incurs the number of risk points shown in Non-Matching Risk Points for that attribute. The
Non-Matching Risk Points values of each non-matching
attribute are added together, resulting in a total risk score. This score
is normalized to be out of 100 as follows:
Total Risk Score = (Total Risk Points
of Failing Attributes / Maximum Risk Points of All Enabled Attributes)
* 100
The resource rule condition fails when the number of non-matching risk
points exceeds the Machine Authentication Risk value defined in this step.
A value of 0 means that a single attribute
difference causes the Device Fingerprint
condition to fail. The default value is 3.
The value between 0-50 can be entered.
The default value is defined by the Machine Risk Limit.
See Modify machine authenticator settings.
b. Click Save.
17. Define the Location History / Known Locations and Travel Velocity conditions. The Risk-Based Authentication (RBA) settings of your Identity as a Service account define the location history and travel velocity conditions. See Manage risk-based authentication settings for more information.
18. Set the Device Certificates risk factor to require the client to perform client-authenticated SSL with a certificate issued from a trusted CA to pass.
19. Set the risk score for application conditions to set the risk percentage a user receives if they fail to meet the condition, as follows:
● Click the dot next to the condition setting and slide the risk scale to the risk percentage
-or-
● Click the 0% and enter the risk points and then click OK.
The default setting is 0%. The Risk percentage determines the authentication requirements as set by the Authentication Decision. When a user attempts to authenticate to an application, the final risk percentage is the sum of all failed conditions.
20. Set the Authentication Decision risk level for Medium Risk and High Risk as follows:
a. Click the risk threshold percentage to the right of Medium Risk or High Risk. The Risk Threshold dialog box appears.
b. Enter the risk percentage.
c. Click OK.
21. Select the Authentication Flows for Low Risk, Medium Risk, and High Risk from the drop-down lists. The Authentication Flows flowchart updates based on your selections.
22. Click Submit to create the resource rule.
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.