Summary

In this chapter, we put on the lens of an end user of Databricks SQL – the business analyst or the data analyst – and learned about the features that enable end users to go through their daily workflows.

First, we learned how to build queries and visualizations and how to compose them into usable dashboards. After that, we learned how to put the dashboards to use with various sharing and alerting features. Finally, we learned how to administer and govern all these artifacts. We learned all this while navigating a hands-on example and compiled our very own operational dashboard.

In this chapter, we assumed that the required computation power is available to us to build and run queries and dashboards. In the next chapter, where we will cover SQL Warehouses, we will go behind the scenes and see how this computation power comes about and how to configure it for the best possible end user experience.