DESCRIBE [EXTENDED] [db_name.]table_name
Return the metadata of an existing table (column names, data types, and comments). If the table does not exist, an exception is thrown.
- Display detailed information about the table, including parent database, table type, storage information, and properties.
DESCRIBE [EXTENDED] [db_name.]table_name PARTITION partition_spec
Return the metadata of a specified partition. The
partition_spec must provide the values for all the partition columns.
- Display basic information about the table and the partition-specific storage information.
New in version runtime-3.3.
DESCRIBE [EXTENDED] [db_name.]table_name column_name
Return the metadata of a specified column.
- Display detailed information about the specified columns, including the column statistics collected by the command
ANALYZE TABLE table_name COMPUTE STATISTICS FOR COLUMNS column_name [column_name, ...].
DESCRIBE DETAIL [db_name.]table_name
Return information about schema, partitioning, table size, and so on. For example, you can see the current reader and writer versions of a table.
DESCRIBE HISTORY [db_name.]table_name
Return provenance information, including the operation, user, and so on, for each write to a table. This information is not recorded by versions of Databricks Runtime below 4.1 and tables created using these versions show this information as
null. Table history is retained for 30 days.
This information is not available if you write into a Databricks Delta table using the following methods: