Connecting BI tools
Although the dashboards for SQL analytics are excellent, you will often find that other BI tooling is needed for some workflows. Here, I will show you how to connect Tableau Desktop to Databricks SQL analytics. Tableau is one of the most common BI dashboarding tools found on the market. However, the setup process is typically very similar if your situation requires a different tool:
- The first step is to click the Partner Connect button on the toolbar. The Partner Connect section lists automated and simplified connectors for common BI tooling.
Figure 7.17: Partner Connect
- You will be presented with the Tableau Connect screen, as shown here. On this screen, you will be able to choose your SQL warehouse.
Figure 7.18: Tableau
- Now, you will be given the connection file for Tableau Desktop to use.
Figure 7.19: The connection file
- Once you run that...
