Duo Single Sign-On for Looker

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

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 Looker. Duo checks the user, device, and network against an application's policy before allowing access to the application.

Configure Single Sign-On

Before configuring Looker 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 Looker application in Duo.

Create the Looker 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 Looker 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 Looker. See Protecting Applications for more information about protecting applications in Duo and additional application options. You'll need the information on the Looker page under Downloads later.

3. Looker uses the Mail attribute, First name attribute, and Last name attribute when authenticating. We've mapped the bridge attributes to Duo Single Sign-On supported authentication source attributes as follows:

   Bridge Attribute	Active Directory	SAML IdP
   <Email Address>	mail	Email
   <First Name>	givenName	FirstName
   <Last Name>	sn	LastName

   If you are using non-standard attributes for your authentication source, check the Custom attributes box and enter the name of the attributes 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 Looker 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 Looker 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.

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.

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 Looker for SSO

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

2. In the left menu sidebar, navigate to Admin → General → Settings.

3. Copy your subdomain name from the Host URL field and paste it into the Duo Admin Panel Subdomain name field.

   Example: If your host url is https://examplestaging.cloud.looker.com, then your subdomain name is examplestaging.

   

4. Return to your Looker account page. In the left menu sidebar, navigate to Authentication → SAML.

5. Click Configure SAML.

6. Return to the Duo Admin Panel. Copy the Metadata URL and paste it into the Looker IdP Metadata (Optional) field.

   

7. Click Load. The IdP URL, IdP Issuer, and IdP Certificate fields auto-populate.

   

8. In your Looker account page, type looker in the SP Entity/IdP Audience (Optional) field.

9. Copy the looker text in the SP Entity/IdP Audience (Optional) field and paste it into the Duo Admin Panel SP Entity/IdP Audience field.

   

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

11. Return to your Looker account page. Under "User Attribute Settings", type mail in the Email Attr field.

12. Type givenName in the FName Attr field.

13. Type sn in the LName Attr field.

    

14. Scroll to the bottom of the page and click Test SAML Authentication. A new window opens and redirects you to Duo Single Sign-On to test the SAML authentication.

15. After the server response is successfully validated, return to your Looker account page window.

16. Scroll to the bottom of the page and click the I have confirmed this configuration checkbox.

17. Click Enable SAML.

Group Mapping

You have the option to map Duo groups to different roles in Looker. To map Duo groups, do the following.

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

2. In the left menu sidebar, navigate to Authentication → SAML.

3. Click Configure SAML.

4. Under "Groups & Roles", click the Mirror SAML Groups toggle switch.

5. Type Groups in the Groups Attribute field.

6. Configure your group settings under Preferred Group Name/Roles/SAML Group ID.

7. Type your group ID in the SAML Group ID field.

   

8. Copy your group ID and paste it into the Duo Admin Panel Looker Groups field.

9. In the Duo Admin Panel, select the applicable Duo group from the Duo groups drop-down menu.

   

10. Scroll to the bottom of the page and click Save.

11. Return to your Looker account page. Scroll to the bottom of the page and click Test SAML Authentication. A new window opens and redirects you to Duo Single Sign-On to test the SAML authentication.

12. After the server response is successfully validated, return to your Looker account page window.

13. Scroll to the bottom of the page and click the I have confirmed this configuration checkbox.

14. Click Enable SAML.

Learn more about Looker SSO at the Looker documentation site.

Using SSO

You can log on to Looker by navigating to your Looker SSO page e.g., https://examplestaging.cloud.looker.com. Click AUTHENTICATE 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 Looker to complete the login process.

* Universal Prompt experience shown.

You can also log into Looker using Duo Central, our cloud-hosted portal which allows users to access all of their applications in one spot. Link to Looker 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 Looker.

Congratulations! Your Looker 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 Looker 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.