How To Connect Tableau To Databricks

Connecting Tableau to Databricks

To connect Tableau to Databricks, follow these steps:

1. Install Required Software: Ensure you have Tableau Desktop (version 2021.4 or later) and the Databricks ODBC driver (version 2.6.19 or later) installed on your computer.
2. Gather Connection Details: Obtain the Server Hostname and HTTP Path for your Databricks compute resource or SQL warehouse.
3. Set Up Authentication: Use OAuth or a Databricks personal access token for authentication. Basic authentication is no longer supported as of July 2024.
4. Connect Tableau to Databricks:
   1. Open Tableau Desktop and click File > New.
   2. On the Data tab, click Connect to Data.
   3. Select Databricks from the list of connectors.
   4. Enter the Server Hostname and HTTP Path.
   5. Choose your authentication method and enter the necessary credentials.
   6. Click Sign In to establish the connection.

Alternatively, you can use Partner Connect to simplify the connection process. Partner Connect allows you to connect Databricks to Tableau Desktop or Tableau Cloud with just a few clicks.

Frequently Asked Questions

1. Q: What is the recommended authentication method for connecting Tableau to Databricks?

   A: OAuth is the recommended authentication method for connecting Tableau to Databricks.

2. Q: Can I use basic authentication to connect Tableau to Databricks?

   A: No, basic authentication using a Databricks username and password is no longer supported as of July 2024.

3. Q: What driver is required to connect Tableau to Databricks?

   A: The Databricks ODBC driver is required to connect Tableau to Databricks.

4. Q: How do I connect Tableau Cloud to Databricks?

   A: To connect Tableau Cloud to Databricks, start a new workbook, select Databricks as the data source, enter the Server Hostname and HTTP Path, and authenticate using OAuth or a personal access token.

5. Q: Can I publish Databricks tables directly to Tableau Cloud?

   A: Yes, you can publish Databricks tables directly to Tableau Cloud using the “Explore in Tableau Cloud” feature from the Databricks UI.

6. Q: What are the requirements for publishing Databricks data to Tableau Cloud?

   A: Your data must be in Unity Catalog, and your compute resource must be Unity Catalog enabled.

7. Q: How long do OAuth tokens for Tableau expire?

   A: OAuth tokens for Tableau expire after 90 days by default, but this can be modified.

Bottom Line: Connecting Tableau to Databricks allows users to leverage powerful analytics capabilities, combining the strengths of both platforms to deliver interactive insights from large datasets. This integration supports various authentication methods and can be simplified using Partner Connect.

👉 Hop on a short call to discover how Fog Solutions helps navigate your sea of data and lights a clear path to grow your business.