A data engineer wants to revert a Delta table to the state it was in at version 5 after a bad MERGE operation introduced incorrect data. Which SQL command achieves this?

Question

Accepted Answer

B. RESTORE TABLE table_name TO VERSION AS OF 5. Delta Lake time travel supports the `RESTORE TABLE` command, which reverts a Delta table to a specified earlier version or timestamp. `RESTORE TABLE table_name TO VERSION AS OF 5` rolls back all data and metadata to version 5. `DELETE FROM` would require knowing exactly which rows were affected by the bad MERGE. `ALTER TABLE SET VERSION` is not a valid Delta Lake command. `VACUUM` deletes old file versions to free storage but does not restore data.

A data engineer wants to revert a Delta table to the state it was in at version 5 after a bad MERGE operation introduced incorrect data. Which SQL command achieves this?

Related Questions

Discussion