Describe Table

Describe Table

DESCRIBE [EXTENDED] [db_name.]table_name

Delta Lake on Databricks

DESCRIBE [EXTENDED] delta.`path-to-table`

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

Delta Lake on Databricks

DESCRIBE [EXTENDED] delta.`path-to-table` 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

DESCRIBE [EXTENDED] [db_name.]table_name column_name

Delta Lake on Databricks

DESCRIBE [EXTENDED] delta.`path-to-table`

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

Delta Lake on Databricks

DESCRIBE FORMATTED delta.`path-to-table`

Return the table format.

Describe Detail (Delta Lake on Databricks)

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.