Summary

In this chapter, we learned how to consult the official SQL command reference for Databricks SQL. More importantly, we learned about some of the Databricks SQL-specific commands. First, we learned about Delta Lake maintenance commands such as VACUUM and RESTORE. We also learned how to control user access at the row and column levels using dynamic view functions. Finally, we learned how to list and describe various data assets using metadata commands.

This brings us to the end of our discussion regarding the concepts, features, and functions of the Databricks SQL platform. In the next chapter, we will learn how to test these concepts, features, and functions at scale with the TPC-DS dataset.