SYSCS_UTIL.SNAPSHOT_TABLE

The SYSCS_UTIL.SNAPSHOT_TABLE system procedure creates a Splice Machine snapshot of the specified table. These snapshots can subsequently be used to restore the table to its state at the time that a snapshot was created.

Snapshots include both the data and indexes for tables.

For more information, see the Using Snapshots topic.

Syntax

SYSCS_UTIL.SNAPSHOT_TABLE( VARCHAR(128) schemaName,
                           VARCHAR(128) tableName,
                           VARCHAR(128) snapshotName );

schemaName

The name of the table’s schema.

tableName

The name of the table for which you are creating a snapshot.

snapshotName

The name that you are assigning to this snapshot, which you can subsequently use to restore or delete the snapshot.

Results

This procedure does not return a result.

Creating a table snapshot can require several minutes of more to complete, depending on the size of the table.

Example

The following example creates a snapshot of the table named myTable:

splice> CALL SYSCS_UTIL.SNAPSHOT_TABLE('mySchema', 'myTable', 'snap_myschema_070417a');
Statement executed.