Snowflake - SAML Relying Party Configuration - SecurID Access Implementation Guide

This section describes how to integrate SecurID Access with Snowflake using Relying Party. Relying party uses SAML 2.0 to integrate SecurID Access as a SAML Identity Provider (IdP) to Snowflake SAML Service Provider (SP).

Architecture Diagram

Configure SecurID Access Cloud Authentication Service

Perform these steps to configure SecurID Access Cloud Authentication Service(CAS) as a relying party SAML IdP to Snowflake .

Procedure

1. Sign into the Cloud Administration Console and browse to Authentication Clients > Relying Parties and click Add a Relying Party. Then select Add for a SAML service provider.

   

    

   

    

2. On Basic Information page enter a Name for the application, ie. Snowflake Then click on Next Step.

3. On Authentication page.

   1. select the RSA SecurID Access manages all authentication.

   2. Select the desired Primary Authentication Method from the dropdown list.

   3. Select the desired policy from the Access Policy for Additional Authentication.

   4. Click Next Step.

      

       

4. On Connection Profile page.

   1. Under the Service Provider Metadata section.

      

       

   2. Enter the Assertion Consumer Service (ACS) . Use the URL format given in Configuring an Identity Provider (IdP) for Snowflake — Snowflake Documentation to configure the ACS and Audience URL for your snowflake account. For example, https://instance5t.us-east-2.aws.snowflakecomputing.com/fed/login.

   3. Enter the Service Provider Entity ID. Use the URL format given in Configuring an Identity Provider (IdP) for Snowflake — Snowflake Documentation to configure the ACS and Audience URL for your snowflake account. For example, https://instance5t.us-east-2.aws.snowflakecomputing.com.

   4. Uncheck SP signs SAML Requests.

   5. Click on Download Certificate. This will be used below in the Snowflake configuration.

   6. Click on Choose File and upload the certificate just downloaded.  This same certificate may be used in the Snowflake configuration below.

   7. Open Advanced Configuration section

      

       

   8. Note the Identity Provider Entity ID field . For Example :https://rsa-inst-pe.auth-demo.securid.com/saml-fe/sso.

5. Click on Save and Finish.

6. Browse to Authentication Clients > Relying Parties

7. Scroll down to the your newly created Relying party and click down arrow to Edit and choose View or Download IdP MetatData and save off the metadata to be used in the Snowflake configuration below.

   

    

8. Click on Publish Changes. Your application is now enabled for SSO. If you make any additional changes to the application configuration you will need to republish.

   

    

Configure Snowflake

Perform these steps to integrate Snowflake with SecurID Access as a Relying Party SAML SP.

Procedure

1. Sign into Snowflake and open  Worksheets tab.

2. Run the command: 

   Copy

   use role accountadmin;
   
   alter account set saml_identity_provider = '{
     "certificate": "XXXXXXXXXXXXXXXXXXX",
     "ssoUrl": "<url>",
     "type": "Custom" }';
   

3. In the certificate parameter, copy and paste the IdP Signing certificate downloaded from RSA Admin Portal while configuring the snowflake application.

4. In the ssoUrl parameter, enter the sso URL configured in the RSA Admin portal for the snowflake application.

5. Enable the sso login page by running the following command.

   Copy

   alter account set sso_login_page = true;

Configuration is complete.

Next Step: See main page for more certification information.