Working with metadata commands
In this section, we will learn about metadata commands, which allow you to list and describe data assets, set configurations, and explore metadata about the data assets. You will be able to use these commands to search for and discover data assets and gain deeper insights into them.
Listing data assets
Two commands can be used to list data assets:
SHOWLIST
The SHOW command is the standard SQL SHOW command. In Databricks, it supports the catalog, database, table, view, and function objects. For example, we can list the tables in the airlines dataset with the following statement:
SHOW TABLES IN airlines;
For an extensive discussion of the SHOW command for the data objects, please revisit Chapter 3, The Data Catalog.
The SHOW statement also supports listing users and groups. It also supports Unity Catalog-specific data assets – external location and storage credential. Please refer to Chapter 11, SQL Commands &...
