Tableau analytics integration with databricks delta lake

Ruby8376 — Fri, 18 Nov 2022 21:50:55 GMT

Hii there!!

Currently, we are exploring options for reporting on Salesforce. We extract data from salesforce via databricks and store it in delta lake.

Is there a connector by which data can be pulled from databricks into Tableau/CRM analytics??

I know that tableau databricks connector exists by which we can integrate databricks with on prem tableau… but looking for options to integrate databricks with CRM analytics!!

thanks in advance!!

Re: Tableau analytics integration with databricks delta lake

emillion25 — Wed, 05 Feb 2025 00:12:50 GMT

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?