SET_TO_SNAPSHOT stored procedure

The SET_TO_SNAPSHOT stored procedure is used to set the current snapshot for a Datalake Iceberg table to a specific snapshot. The snapshot the table is to be set to can be any snapshot

Syntax

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

Description

'schema'
An input argument that specifies the Datalake Iceberg table schema name.
'table name'
The name of the Iceberg table whose state is to be set to.
'snapshot id'
The ID of the snapshot that should be set as the table’s current snapshot.
'message'
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 SET_TO_SNAPSHOT stored procedure is restricted to users with Db2 administrative privileges.