Question

A data engineer notices that a critical Delta table in the silver layer has produced unexpected row counts after a series of overnight jobs. Before deciding whether to roll back, they need to review a chronological log of every operation performed on the table, including the operation type (WRITE, MERGE, DELETE), the user, and the version number for each change. Which approach lets them retrieve this information directly?

Accepted Answer

Run DESCRIBE HISTORY on the Delta table to view the transaction log of versions and operations

Answer

Run DESCRIBE DETAIL on the Delta table to list the version-by-version operation log

Answer

Query the table using a VERSION AS OF clause for each possible version until the change is found

Answer

Run VACUUM on the table to expose the retained history of prior operations