Which is the correct way to write a previous version of a Delta Table?

[amaaiia]

Hi.

I want to set T1 table old version as current version. One way is to read the old version with a notebook and overwrite the table with that version. Is there any other approach?

Thanks

[nilendraFabric · Accepted solution]

Hello @amaaiia 

The RESTORE command is designed to roll back a Delta Table to an earlier state. This operation updates the table metadata to point to the specified version, effectively making it the current version. However, it does not delete other versions, so you can still access them if needed.

This approach is more efficient than manually reading an old version and overwriting the table. The RESTORE command allows you to revert the table to a specific version or timestamp directly, without creating a new version through manual operations.


Thanks 

[parkergeis]

What occurs when you restore a table to a previous version then have an update operation like append rows? Does it append to the current/restored version or does it append to the most recent (pre-restored) version?

[nilendraFabric]

new data will be appended to the restored version, which becomes the current state of the table.