Viewing History Operation Records of a Delta Table
Syntax
DESCRIBE HISTORY [database_name.]table_name|DELTA.`obs_path` [LIMIT n]
Example
DESCRIBE HISTORY delta_table0; DESCRIBE HISTORY delta.`obs://tablePath` LIMIT 1;
System Response
Returns the table's historical operations, with the meaning of the result indicators shown in the following table.
| 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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
