Dremio Cloud
Dremio Software
 
On this page

    ROLLBACK TABLE

    Roll back an Iceberg table to a previous snapshot using either a timestamp or a snapshot ID. For more information about rolling back tables, see Rolling Back Tables.

    Syntax 
    ROLLBACK TABLE <table_name> 
   TO { [ SNAPSHOT '<snapshot_id>' ] | [ TIMESTAMP '<timestamp>' ] }

    Parameters

    <table_name>

    String

    The path of the Iceberg table that you want to roll back.

    TO { [ SNAPSHOT '<snapshot_id>' ] | [ TIMESTAMP '<timestamp>' ] }

    String

    Specifies whether you are rolling back to a specific snapshot or to a certain point in time:

    • TO SNAPSHOT '<snapshot_id>': The snapshot ID that you want to roll back to. Must be contained in single quotes.

    • TO TIMESTAMP '<timestamp>': The timestamp that you want to roll back to. If the timestamp matches a snapshot's timestamp exactly, the Iceberg table is rolled back to that snapshot. Otherwise, the table is rolled back to the last snapshot before the specified timestamp. Must be contained in single quotes.

    Examples

    Roll back the table to the specified snapshot ID 
    ROLLBACK TABLE demo.example_table TO SNAPSHOT ’2489484212521283189’
    Roll back the table based on the specified timestamp 
    ROLLBACK TABLE demo.example_table TO TIMESTAMP ’2022-06-22 17:06:00’