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