CREATE OR REPLACE SNAPSHOT

The CREATE OR REPLACE SNAPSHOT statement creates a named snapshot that you can use to start other jobs or keep as a backup.

After you create a snapshot, the job will continue running. If you want to cancel the job after creating a snapshot, use the DROP JOB WITH SNAPSHOT statement.

Syntax Summary

This code block is a quick reference with all the parameters that you can use with the CREATE OR REPLACE SNAPSHOT statement.

See some practical examples.

CREATE OR REPLACE SNAPSHOT snapshot_name FOR JOB job_name

Parameters

The CREATE OR REPLACE SNAPSHOT statement accepts the following parameters.

All of these parameters are required.

Parameter Description Example

snapshot_name

Name the snapshot. If the snapshot already exists, it is overwritten.

job_name

Define the job for which to create the snapshot.

Examples

This section lists some example SQL queries that show you how to use the CREATE OR REPLACE SNAPSHOT statement.

Create a Snapshot

CREATE OR REPLACE SNAPSHOT track_trades_snapshot FOR JOB track_trades;