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:
CREATE TABLE table1
BACKUP NO
AS SELECT * FROM table_test;Output Code:
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:
CREATE TABLE table1
BACKUP YES
AS SELECT * FROM table_test;Output Code:
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.
Last updated