Creating dashboards in Databricks SQL

Azure Databricks Databricks SQL allows users to create various dashboards based on the queries and visualizations that are already built. This helps businesses to get a visual representation of data for various KPIs.

In this recipe, you will learn how to create visualizations in Databricks SQL and how to pin a visualization from various queries to the dashboard.

Getting ready

Before starting, we need to ensure we have executed the following notebook. The following notebook creates the required tables on which we can build our visualizations and dashboard:

https://github.com/PacktPublishing/Azure-Databricks-Cookbook/blob/main/Chapter07/7.1-End-to-End%20Data%20Pipeline.ipynb

Also create the visualization as mentioned in the Introduction to visualizations in Databricks SQL recipe.

How to do it…

Let's learn how to create a dashboard by running through the following steps:

1. From the Databricks SQL homepage go...