Snowflake - SAML SSO Agent Configuration - SecurID Access Implementation Guide

This section describes how to integrate SecurID Access with Snowflake using a SAML SSO Agent.

Architecture Diagram

Configure SecurID Access Cloud Authentication Service

Perform these steps to configure SecurID Access Cloud Authentication Service(CAS) as an SSO Agent SAML IdP to Snowflake.

Procedure

1. Sign into the SecurID Access Cloud Administration Console and browse to Applications > Application Catalog.

2. Click on Create From Template then click Select for SAML Direct.

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

4. On Connection Profile page.

   1. Choose IDP-Initiated.

      

       

   
   
   1. In Connection URL for IDP-Initiated take defaults.

   2. Note the Identity Provider URL and Issuer Entity ID. These values are automatically generated. They may be needed later for the configuration of Snowflake.

      

       

   3. Click on Generate Cert Bundle, set a a common name for your company certificate. Then click Generate and Download .

   4. Select Choose File and upload the private key from the generated certificate bundle.

   5. Select Choose File and upload the cert from the generated certificate bundle.

   6. Select Include Certificate on Outgoing Assertion.

   7. Scroll down to Service Provider section.

   8. For 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.

   9. For the Audience (Service Provider Issuer 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.

      

       

   10. Scroll down to User Identity section.

   11. Ensure Identifier Type = Email Address, set your Identity Source and Property = mail.

       

        

   12. Click Next Step.

5. On User Access page select the Access Policy you require. Allow All Authenticated Users is the least restrictive. Click Next Step.

   

    

6. On Portal Display Page.

   1. Select Display in Portal.

   2. Upload an Application Icon if you wish.

   3. Set an Application Tooltip if you wish.

   4. Click on Save and Finish.

7. For this new Connector, click on the down arrow next to the Edit button and Export Metadata to save off the IDP metadata information for configuration of Snowflake.

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 as an SSO Agent SAML SP to SecurID Access Cloud Authentication Service.

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: Head back to the main page.