Duo Single Sign-On for Snowflake

Overview

As business applications move from on-premises to cloud hosted solutions, users experience password fatigue due to disparate logons for different applications. Single sign-on (SSO) technologies seek to unify identities across systems and reduce the number of different credentials a user has to remember or input to gain access to resources.

While SSO is convenient for users, it presents new security challenges. If a user's primary password is compromised, attackers may be able to gain access to multiple resources. In addition, as sensitive information makes its way to cloud-hosted services it is even more important to secure access by implementing two-factor authentication and zero-trust policies.

About Duo Single Sign-On

Duo Single Sign-On is our cloud-hosted SSO product which layers Duo's strong authentication and flexible policy engine on top of Snowflake logins. Duo Single Sign-On acts as an identity provider (IdP), authenticating your users using existing on-premises Active Directory (AD) or another SSO IdP. Duo SSO prompts users for two-factor authentication and performs endpoint assessment and verification before permitting access to Snowflake.

Duo Single Sign-On is available in Duo Premier, Duo Advantage, and Duo Essentials plans, which also include the ability to define policies that enforce unique controls for each individual SSO application. For example, you can require that Salesforce users complete two-factor authentication at every login, but only once every seven days when accessing Snowflake. Duo checks the user, device, and network against an application's policy before allowing access to the application.

Configure Single Sign-On

Before configuring Snowflake with Duo SSO using Security Assertion Markup Language (SAML) 2.0 authentication you'll first need to enable Duo Single Sign-On for your Duo account and configure a working authentication source.

Once you have your SSO authentication source working, continue to the next step of creating the Snowflake application in Duo.

Create the Snowflake Application in Duo

1. Log on to the Duo Admin Panel and navigate to Applications → Protect an Application.

2. Locate the entry for Snowflake with a protection type of "2FA with SSO hosted by Duo (Single Sign-On)" in the applications list. Click Protect to the far-right to start configuring Snowflake. See Protecting Applications for more information about protecting applications in Duo and additional application options. You'll need the information on the Snowflake page under Downloads later.

3. Snowflake uses the Mail attribute when authenticating. We've mapped the <Email Address> bridge attribute to Duo Single Sign-On supported authentication source attributes as follows:

   Bridge Attribute	Active Directory	SAML IdP
   <Email Address>	mail	Email

   If you are using a non-standard email attribute for your authentication source, check the Custom attributes box and enter the name of the attribute you wish to use instead.

   

4. You can adjust additional settings for your new SAML application at this time — like changing the application's name from the default value, enabling self-service, or assigning a group policy.

5. Keep the Duo Admin Panel tab open. You will come back to it later.

Duo Universal Prompt

The Duo Universal Prompt provides a simplified and accessible Duo login experience for web-based applications, offering a redesigned visual interface with security and usability enhancements.

Universal Prompt	Traditional Prompt

We've already updated the Duo Snowflake application hosted in Duo's service to support the Universal Prompt, so there's no action required on your part to update the application itself. If you created your Snowflake application before March 2024, you can activate the Universal Prompt experience for users from the Duo Admin Panel. Snowflake applications created after March 2024 have the Universal Prompt activated by default.

If you created your Snowflake application before March 2024, it's a good idea to read the Universal Prompt Update Guide for more information, about the update process and the new login experience for users, before you activate the Universal Prompt for your application.

Activate Universal Prompt

Activation of the Universal Prompt is a per-application change. Activating it for one application does not change the login experience for your other Duo applications.

The "Universal Prompt" area of the application details page shows that this application is "Ready to activate", with these activation control options:

• Show traditional prompt: Your users experience Duo's traditional prompt via redirect when logging in to this application.
• Show new Universal Prompt: (Default) Your users experience the Universal Prompt via redirect when logging in to this application.

The application's Universal Prompt status shows "Activation complete" here and on the Universal Prompt Update Progress report.

Should you ever want to roll back to the traditional prompt, you can return to this setting and change it back to Show traditional prompt. However, this will still deliver the Duo prompt via redirect, not in an iframe. Keep in mind that support for the traditional Duo prompt ended for the majority of applications in March 2024.

Universal Update Progress

Click the See Update Progress link to view the Universal Prompt Update Progress report. This report shows the update availability and migration progress for all your Duo applications. You can also activate the new prompt experience for multiple supported applications from the report page instead of visiting the individual details pages for each application.

Enable Snowflake for SSO

1. Log into your Snowflake account as an administrative user.

2. In the left menu sidebar, click Worksheets.

3. Click the + icon in the upper right corner of the page, and then click SQL Worksheet.

   

4. Your worksheet is automatically named with the date and time created. Click ... next to your created folder and click Rename. Rename the folder with your desired name.

   

5. Go to the Snowflake "Configuring Snowflake to use Federated Authentication" article and copy the example create security integration SQL command from the "Create a SAML2 Security Integration" section. Return to your Snowflake account page and paste the SQL command into the worksheet.

   

6. Make the following changes to the create security integration SQL command in the worksheet:

   1. Delete line 8 SAML2_SNOWFLAKE_ISSUER_URL and line 9 SAML2_SNOWFLAKE_ACS_URL.

   2. On line 1, change my_idp to a unique name for your security integration.

   3. Return to the Duo Admin Panel. Copy the Identity Provider Issuer URL and paste it over https://example.com on line 4 of the create security integration SQL command in the Snowflake worksheet.

      Example: https://sso-abc1def2.sso.duosecurity.com/saml2/sp/DIABC123678901234567/metadata

   4. Return to the Duo Admin Panel. Copy the Identity Provider SSO URL and paste it over http://myssoprovider.com on line 5 of the create security integration SQL command in the Snowflake worksheet.

      Example: https://sso-abc1def2.sso.duosecurity.com/saml2/sp/DIABC123678901234567/sso

   5. On line 6, change ADFS to Custom.

   6. Return to the Duo Admin Panel with the Snowflake application open. Under "Downloads", click Copy certificate. Return to Snowflake and paste the certificate file text over my_x509_cert on line 7 of the create security integration SQL command in the Snowflake worksheet, deleting the -----BEGIN CERTIFICATE----- and -----END CERTIFICATE----- lines from the pasted certificate text.

   7. Create two new lines below the certificate text. On the first new line, type SAML2_ENABLE_SP_INITIATED = true.

   8. On the second new line, type SAML2_SP_INITIATED_LOGIN_PAGE_LABEL = 'My IdP'. Replace My IdP with the desired name for your login page.

      Example: SAML2_SP_INITIATED_LOGIN_PAGE_LABEL = 'Acme_IdP'

      Your edited SQL command should look similar to this:

   

7. Click the Play icon in the upper right corner of the page to create the security integration for SSO.

8. Now you need to create another SQL worksheet. In the left menu sidebar, click the + icon and then click SQL Worksheet.

9. Click ... next to your created folder and click Rename. Rename the folder with your desired name.

10. On line 1 of the new SQL worksheet, type user role accountadmin;.

11. Create a new line 2 and type desc security integration my_idp;. Replace my_idp with the name you created for your security integration on line 1 of the SQL command template.

    

12. Click the Play icon in the upper right corner of the page. The results are displayed.

13. In the results table, scroll down to line 14 SAML2_SNOWFLAKE_METADATA. Click the cell in the "property_value" column. The "As property_value" field opens to the right of the results table.

14. Hover your mouse cursor over the "As property_value" field and click the Expand icon to view the data.

15. Copy the entity ID URL and paste it into the Duo Admin Panel Snowflake Issuer URL field.

    

16. Return to your Snowflake account page and scroll to the bottom of the "As property_value" field. Copy the URL after "Default="true"" and paste it into the Duo Admin Panel Snowflake ACS URL field.

    

17. In the Duo Admin Panel, scroll to the bottom of the page and click Save.

Learn more about Snowflake SSO at Snowflake Documentation.

Using SSO

You can log on to Snowflake by navigating to your Snowflake SSO page e.g., https://example-example.snowflakecomputing.com/. Click Sign in using Example to be redirected to Duo Single Sign-On to begin authentication.

Active Directory Login

With Active Directory as the Duo SSO authentication source, enter the primary username (email address) on the Duo SSO login page and click or tap Next.

Enter the AD primary password and click or tap Log in to continue.

Enable Duo Passwordless to log in to Duo SSO backed by Active Directory authentication without entering a password in the future.

SAML Login

With another SAML identity provider as the Duo SSO authentication source, Duo SSO immediately redirects the login attempt to that SAML IdP for primary authentication. Users do not see the Duo SSO primary login screen.

Duo Authentication

Successful verification of your primary credentials by Active Directory or a SAML IdP redirects back to Duo. Complete Duo two-factor authentication when prompted and then you'll return to Snowflake to complete the login process.

* Universal Prompt experience shown.

You can also log into Snowflake using Duo Central, our cloud-hosted portal which allows users to access all of their applications in one spot. Link to Snowflake in Duo Central by adding it as an application tile. Once the tile has been added, log into Duo Central and click the tile for IdP-initiated authentication to Snowflake.

Congratulations! Your Snowflake users now authenticate using Duo Single Sign-On.

See the full user login experience, including expired password reset (available for Active Directory authentication sources) in the Duo End User Guide for SSO.

Enable Remembered Devices

To minimize additional Duo two-factor prompts when switching between Snowflake and your other Duo Single Sign-On SAML applications, be sure to apply a shared "Remembered Devices" policy to your SAML applications.

Troubleshooting

Need some help? Try searching our Knowledge Base articles or Community discussions. For further assistance, contact Support.