Using Business Intelligence Tools with Databricks SQL
Databricks SQL is a well-rounded, self-contained data analytics platform. It provides users such as analysts and data administrators with all the tools that are required for them to conduct their daily workflows. As we saw in the preceding chapters, pretty much everything can be done on Databricks SQL – exploratory data analysis, reports, dashboards, alerts, and more.
Despite all that, though, it is by no means a replacement for dedicated Business Intelligence (BI) tools such as Power BI, Tableau, Looker, or Qlik.
These BI tools can connect with Databricks SQL with simple, transparent mechanisms to query the data on the data lakehouse. In this chapter, we will focus on how to connect Databricks SQL to BI tools of your choice.
The primary audience of this chapter is analysts who want to use BI tools of their choice with Databricks SQL. The database administrator personas will also benefit from this chapter as it...