Answer-first summary for fast verification
Answer: SELECT * FROM table VERSION AS OF <version_number>
Explanation: To retrieve data from a Delta Lake table as it existed at a specific version, use the VERSION AS OF <version_number> clause in your SQL query. Reference: https://docs.databricks.com/aws/en/delta#query-an-older-snapshot-of-a-table-time-travel
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you retrieve data from a Delta Lake table as it existed at a specific version?
A
SELECT * FROM table VERSION AS OF <version_number>
B
SELECT * FROM table TIMESTAMP AS OF '<timestamp>'
C
SELECT * FROM table AS OF VERSION <version_number>
D
SELECT * FROM table AS OF TIMESTAMP '<timestamp>'
No comments yet.