DESCRIBE HISTORY

Applies to: check marked yes Databricks SQL Databricks Runtime

Returns provenance information, including the operation, user, and so on, for each write to a table. Table history is retained for 30 days.

Syntax

DESCRIBE HISTORY table_name

table_name

Identifies an existing Delta table. The name must not include a temporal specification or options specification.

Documentație

Work with Delta Lake table history - Azure Databricks

Review and navigate Delta Lake table versions using table history and time travel commands.
Review Delta Lake table details with describe detail - Azure Databricks

View Delta Lake table details, configurations, and metadata with the describe detail command.
RESTORE - Azure Databricks - Databricks SQL

Learn how to use the RESTORE syntax of the Delta Lake SQL language in Databricks SQL and Databricks Runtime.
Delta table properties reference - Azure Databricks

Reference list for Delta Lake table properties in Azure Databricks.
Upsert into a Delta Lake table using merge - Azure Databricks

Upsert data into a Delta Lake table using merge on Azure Databricks.
Update Delta Lake table schema - Azure Databricks

Manual or automatic table schema updates to add, rename, or drop columns with Delta Lake.
VACUUM - Azure Databricks - Databricks SQL

Learn how to use the VACUUM syntax of the SQL language in Databricks SQL and Databricks Runtime.
REFRESH TABLE - Azure Databricks - Databricks SQL

Learn how to use the REFRESH TABLE syntax of the SQL language in Databricks Runtime.