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:
- In Tableau, go to Connect โ Databricks.
- Enter your Databricks SQL Warehouse (formerly SQL Endpoint) credentials.
- 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?
