emillion25
New Contributor III

Hello @ruby 

Were you able to resolve this? I know it's been a while, but I believe we now have multiple ways to connect Tableau and Databricks.

1. Use the Native Databricks Connector for Tableau

  • Tableau has a built-in Databricks connector, making it easy to connect to your Delta Lake tables directly.
  • Steps to connect:
    1. In Tableau, go to Connect → Databricks.
    2. Enter your Databricks SQL Warehouse (formerly SQL Endpoint) credentials.
    3. Select the Delta Lake tables you need.
  • This provides live queries and direct data access to your Databricks environment.

🔗Reference: https://docs.databricks.com/en/partners/bi/tableau.html


2. Connecting Databricks to Salesforce CRM Analytics (formerly Tableau CRM)

If you specifically want Databricks data in Salesforce CRM Analytics, you have a few options:

A. Use JDBC to Pull Data from Databricks

  • CRM Analytics supports external data ingestion via JDBC.
  • You can configure CRM Analytics to connect to Databricks SQL Warehouse using JDBC.
  • This allows CRM Analytics to query Delta Lake tables directly.

B. Export Delta Lake Data to Salesforce via API

  • If you need a batch sync, Databricks can export data to Salesforce objects using the Salesforce Bulk API.
  • Once in Salesforce, the data can be used within CRM Analytics dashboards.

🔗Reference: https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/ 

 


 

3. Tableau Bridge for Cloud-Based Access

  • If your Tableau deployment is in Salesforce Cloud or Tableau Online, you may need to use Tableau Bridge to securely connect to Databricks.
  • Tableau Bridge keeps data refreshed without requiring direct database exposure.

🔗Reference: https://www.tableau.com/support/releases/bridge

Did you end up using any of these?