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.