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.

note

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.

sql

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.	Create a Snapshot
job_name	Define the job for which to create the snapshot.	Create a Snapshot

Examples

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

Create a Snapshot

sql

CREATE OR REPLACE SNAPSHOT track_trades_snapshot FOR JOB track_trades;