Explanation:
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
Ultimate access to all questions.
No comments yet.
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>'