Configure Azure Databricks sign-on from Tableau Server

Article
08/07/2024

This article describes how to configure Azure Databricks sign-on from Tableau Server. After you complete this one-time configuration as an Azure Databricks account admin, users can connect from Tableau Server using SSO authentication.

The steps in this article aren’t needed for Tableau Desktop and Tableau Cloud, which are enabled as OAuth applications in your Azure Databricks account by default.

This article is specific to custom Tableau Server OAuth application creation. For generic custom OAuth application creation steps, see the following:

Enable custom OAuth applications using the CLI

Before you begin

Before you configure Azure Databricks sign-on from Tableau Server:

You must be an Azure Databricks account administrator.
Install the Databricks CLI and set up authentication between the Databricks CLI and your Databricks account.

You must also meet the following Tableau requirements:

You have a Tableau Server installation with one of the following versions:
- 2021.4.13 or above
- 2022.1.9 or above
- 2022.3.1 or above
You’re a Tableau Server administrator.

Add Tableau Server as an OAuth application

To add Tableau Server as an OAuth application to your Azure Databricks account, do the following:

Locate your account ID.
Locate your Tableau Server URL.
Run the following command:
```
databricks account custom-app-integration create --confidential --json '{"name":"<name>", "redirect_urls":["<redirect-url>"], "scopes":["all-apis", "offline_access", "openid", "profile", "email"]}'
```
- Replace <name> with a name for your custom OAuth application.
- For <redirect-url>, append /auth/add_oauth_token to your Tableau Server URL. For example, https://example.tableauserver.com/auth/add_oauth_token.
For more information about supported values, see POST /api/2.0/accounts/{account_id}/oauth2/custom-app-integrations in the REST API reference.

A client ID and a client secret are generated, and the following output is returned:
```
{"integration_id":"<integration-id>","client_id":"<client-id>","client_secret":"<client-secret>"}
```
Note

Enabling an OAuth application can take 30 minutes to process.
Securely store the client secret.

Important

You can’t retrieve the client secret later.

Configure OAuth in Tableau Server

To configure OAuth in Tableau Server, do the following:

Sign in to Tableau Server as a server administrator.
In the sidebar, click Settings > OAuth Client Registry > Add OAuth client.
For Connection Type, select Databricks.
For Client ID, enter the client ID that was generated in Add Tableau Server as an OAuth application.
For Client Secret, enter the client secret that was generated in Add Tableau Server as an OAuth application.
For Redirect URL, enter the redirect URL from Add Tableau Server as an OAuth application.
Click Add OAuth client.

Troubleshoot OAuth configuration

This section describes how to resolve common issues with OAuth configuration.

404 error from your IdP

Issue: When you try to authenticate to Tableau Server, you see a 404 error.

Cause: OAuth is misconfigured.

Solution: Ensure that you have correctly configured OAuth.

Next steps

Users can now use SSO to authenticate to Azure Databricks from Tableau Server. See Connect Tableau and Azure Databricks.

Share via