BACKUP

Description

Enables Amazon Redshift to automatically adjust the encoding type for all columns in the table to optimize query performance. In Snowflake, the concept of BACKUP as seen in other databases is not directly applicable. Snowflake automatically handles data backup and recovery through its built-in features like Time Travel and Fail-safe, eliminating the need for manual backup operations. For these reasons, the statement BACKUP is removed during the transformation process

Click here to navigate to the Amazon Redshift docs page for this syntax.

Grammar Syntax

BACKUP { YES | NO }

Sample Source Patterns

NO option

An FDM is added since Snowflake, by default, always creates a backup of the created table.

Input Code:

Redshift

IN -> Redshift_01.sql

CREATE TABLE table1
BACKUP NO
AS SELECT * FROM table_test;

Output Code:

Snowflake

OUT -> Redshift_01.sql

CREATE TABLE table1
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "02/10/2025",  "domain": "test" }}'
----** SSC-FDM-RS0001 - BACKUP NO OPTION NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE. **
--BACKUP NO
AS SELECT * FROM
table_test;

YES option

The option is removed since Snowflake, by default, applies a backup to the created table.

Input Code:

Redshift

IN -> Redshift_01.sql

CREATE TABLE table1
BACKUP YES
AS SELECT * FROM table_test;

Output Code:

Snowflake

OUT -> Redshift_01.sql

CREATE TABLE table1
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "02/10/2025",  "domain": "test" }}'
AS SELECT * FROM
table_test;

Related EWIs

• SSC-FDM-RS0001: "Option" not supported. Data storage is automatically handled by Snowflake.