Viewing History Operation Records of a Delta Table

DESCRIBE HISTORY [database_name.]table_name|DELTA.`obs_path` [LIMIT n]

DESCRIBE HISTORY delta_table0;
DESCRIBE HISTORY delta.`obs://tablePath` LIMIT 1;

Returns the table's historical operations, with the meaning of the result indicators shown in the following table.

**Table 1** Result metrics
Metric	Description
version	Version number of the table operation
timestamp	Timestamp of the current version operation
userId	User ID of the current version operation
userName	Username of the current version operation
operation	Operation name (e.g., WRITE, CREATE TABLE, UPDATE, DELETE, MERGE, RESTORE)
operationParameters	Operation parameters
job	Detailed information about the job running the operation
notebook	Detailed information about the notebook running the operation
clusterId	Cluster ID
readVersion	Table version read for the write operation
isolationLevel	Isolation level
isBlindAppend	Whether data is appended
operationMetrics	Metrics of the operation (e.g., number of files modified, rows modified, bytes modified)
engineInfo	Information on Spark and Delta versions