Skip navigation
Documentation

Duo Single Sign-On for Snowflake

Last Updated: March 25th, 2024

Add two-factor authentication and flexible security policies to Snowflake SAML 2.0 logins with Duo Single-Sign On. Our cloud-hosted SSO identity provider offers inline user enrollment, self-service device management, and support for a variety of authentication methods — such as passkeys and security keys, Duo Push, or Verified Duo Push — in the Universal Prompt.

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.

  2. Click Protect an Application and 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.

    Duo Snowflake Custom Attributes Checkbox
  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
 Duo Push in Universal Prompt  Duo Push in 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. You can activate the Universal Prompt experience for users of new and existing Duo Snowflake applications from the Duo Admin Panel.

Before you activate the Universal Prompt for your application, 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.

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: (Default) Your users experience Duo's traditional prompt via redirect when logging in to this application.
  • Show new Universal Prompt: Your users experience the Universal Prompt via redirect when logging in to this application.

Universal Prompt Info - Application Ready for Universal Prompt

Enable the Universal Prompt experience by selecting Show new Universal Prompt, and then scrolling to the bottom of the page to click Save.

Once you activate the Universal Prompt, the application's Universal Prompt status shows "Activation complete" here and on the Universal Prompt Update Progress report.

Universal Prompt Info - Universal Prompt Activation Complete

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.

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.

    Snowflake 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.

    Snowflake Rename the SQL Worksheet
  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.

    Snowflake SQL Worksheet Template
  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:

    Snowflake Completed SQL Worksheet
  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.

    Snowflake Second SQL Worksheet
  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.

    Snowflake Issuer URL
  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.

    Snowflake ACS URL
  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.

Duo Single Sign-On Login

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

Duo Single Sign-On Password

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.

Duo Universal Prompt

* 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.