Describe Table

Describe Table

DESCRIBE [EXTENDED] [db_name.]table_name

DESCRIBE [EXTENDED] delta.`path-to-table` (Managed Delta Lake)

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

DESCRIBE [EXTENDED] delta.`path-to-table` PARTITION partition_spec (Managed Delta Lake)

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

DESCRIBE [EXTENDED] delta.`path-to-table` (Managed Delta Lake)

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

DESCRIBE FORMATTED delta.`path-to-table` (Managed Delta Lake)

Return the table format.

Describe Detail (Delta Lake)

DESCRIBE DETAIL [db_name.]table_name

DESCRIBE DETAIL delta.`path-to-table`

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

DESCRIBE HISTORY [db_name.]table_name

DESCRIBE HISTORY delta.`path-to-table`

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 Delta Lake table using the following methods: