12

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 ...

Get Business Intelligence with Databricks SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.