Using Splice Machine Snapshots

This topic describes how to use the Splice Machine snapshot feature to create a restorable snapshot of a table or schema; this is commonly used when importing or deleting a significant amount of data from a database.

Overview

Snapshots allow you to create point-in-time backups of tables (or an entire schema) without actually cloning the data.

Snapshots include both the data and indexes for tables.

You use these system procedures and tables to work with snapshots:

  • Use the  SYSCS_UTIL.SNAPSHOT_TABLE system procedure to create a named snapshot for a table.
  • Use the  SYSCS_UTIL.SNAPSHOT_SCHEMA system procedure to create a named snapshot for a schema.
  • Use the  SYSCS_UTIL.RESTORE_SNAPSHOT system procedure to restore a table or schema from a named snapshot.
  • Use the  SYSCS_UTIL.DELETE_SNAPSHOT system procedure to delete a named snapshot.
  • Information about stored snapshots, including their names, is found in the  SYS.SYSSNAPSHOTS system table.

    The SYS.SYSSNAPSHOTS table is part of the SYS schema, to which access is restricted for security purposes. You can only access tables in the SYS schema if you are a Database Administrator or if your Database Administrator has explicitly granted access to you.