ROLLBACK_ TO_TIMESTAMP stored procedure

The ROLLBACK_TO_TIMESTAMP stored procedure is used to roll back a Datalake Iceberg table to a specific snapshot taken before the specified timestamp. The snapshot for the point in time to be rolled back to must be an ancestor of the current snapshot.

Syntax

Read syntax diagramSkip visual syntax diagramROLLBACK_TO_TIMESTAMP(schema,table name, timestamp)

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.
'timestamp'
The timestamp that represents the point in time the table is to be rolled back to. The timestamp must be formatted as yyyy-MM-dd HH:mm:ss.SSS.
'message'
An output message indicating the success or failure of the procedure. The message includes the timestamp 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_TIMESTAMP stored procedure is restricted to users with Db2 administrative privileges.