Retrieving Last Data and Metadata Refresh DateTimes of table in Databricks

gayatrikhatale
Contributor

Hi, 

I had a query regarding how to accurately retrieve the last data refresh datetime and last metadata refresh datetime for tables in Databricks. Currently, the only reliable approach I am aware of is using the DESCRIBE HISTORY command with filters on operations column such as WRITE, UPDATE, DELETE, MERGE, or ALTER TABLE.

However, I could not find a comprehensive list of all possible operations that can appear in the operation column of DESCRIBE HISTORY so I can separate them. The documentation here — Databricks Delta Table History — only provides examples of operation metric key values, but not the full list of supported operations.

Could you please help me.

Thank you!