ROLLBACK_TO SNAPSHOT stored procedure

The ROLLBACK_TO_SNAPSHOT stored procedure is used to roll back a Datalake Iceberg table to a specific snapshot ID. The snapshot to be rolled back to must be an ancestor of the current snapshot.

Syntax

Read syntax diagramSkip visual syntax diagramROLLBACK_TO_SNAPSHOT(schema,table name, snapshot id)

Description

'schema'
An input argument that specifies the Datalake Iceberg table schema name.
'table name'
An input argument that specifies the name of the Iceberg table whose state is to be rolled back.
'snapshot id'
An input argument that specifies the snapshot id the table is to be rolled back to.
'message'
An output message indicating the success or failure of the procedure. The message includes the snapshot ID the table was rolled back to. If the procedure failed, the message includes an explanation indicating why it failed.

Authorization

Execution of the ROLLBACK_TO_SNAPSHOT stored procedure is restricted to users with Db2 administrative privileges.