SQL Commands – Part 2
Maintaining and managing data and data access in any database system is a continuous process. The Lakehouse is no different. In this chapter, we will focus on the SQL commands that help us maintain and manage our Lakehouse. We will also learn about Lakehouse-specific SQL commands for discovering data assets. Finally, we will learn about advanced security programming techniques available on the Lakehouse.
In this chapter, we will cover the following main topics:
- Working with Delta Lake maintenance commands
- Working with data security commands
- Working with metadata commands
Note
This chapter is not intended as a complete SQL command reference. We will cover the practical usage of SQL commands that are specific to Databricks SQL and the Lakehouse. The rest of the standard SQL commands can be studied at https://docs.databricks.com/sql/language-manual/index.html.
