Answer-first summary for fast verification
Answer: Use the DESCRIBE HISTORY command to view the table history and identify the user.
The DESCRIBE HISTORY command provides a detailed history of transactions on the Delta Lake table, including the user who performed each transaction. This is the most efficient way to identify the user who performed the last update.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Consider a scenario where you have a Delta Lake table named 'sales_data' that has been updated multiple times over the past year. You need to identify the user who performed the last update on this table. How would you achieve this using Databricks SQL or PySpark?
A
Use the DESCRIBE HISTORY command to view the table history and identify the user.
B
Use the SHOW CREATE TABLE command to view the table creation details.
C
Use the SELECT * FROM sales_data command to inspect the data.
D
Use the VACUUM command to clean up the table and view the history.