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

RedShift Input Code:

IN -> Redshift_01.sql

CREATE TABLE table1
BACKUP YES
AS SELECT * FROM table_test;

Snowflake Output Code:

OUT -> Redshift_01.sql

CREATE TABLE table1
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "09/17/2024" }}'
AS SELECT * FROM
table_test;

Related EWIs

There are no known issues.