Describe Table

Describe Table

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.

EXTENDED
Display detailed information about the table, including parent database, table type, storage information, and properties.

Describe Partition

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.

EXTENDED
Display basic information about the table and the partition-specific storage information.

Describe Columns

New in version runtime-3.3.

DESCRIBE [EXTENDED] [db_name.]table_name column_name

Return the metadata of a specified column.

EXTENDED
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 Formatted

DESCRIBE FORMATTED [db_name.]table_name

Return the table format.

Describe Detail (Databricks Delta)

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 (Databricks Delta)

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.

Describe Formatted

DESCRIBE FORMATTED [db_name.]table_name

Return the table format.