Reserved Keywords

Reserved keywords translation for Redshift

Description

In Redshift you can use some of the Snowflake reserved keywords as column names, table names, etc. For this reason, it is necessary that these words are enclosed in double quotes in order to be able to use them.

Please be aware that in Snowflake when these names are enclosed in double quotes, they are case-sensitive. For this reason It is important to emphasize that when a reserved keyword is used in Snowflake it is always transformed with double quotes and in lowercase. For more information please refer to Snowflake identifiers documentation.

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

CREATE TABLE alter
(
    alter INT
);

CREATE TABLE CONNECT
(
    CONNECT INT
);

DROP TABLE alter;
DROP TABLE CONNECT;

Output Code:

Snowflake

OUT -> Redshift_01.sql

CREATE TABLE "alter"
(
    "alter" INT
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "09/17/2024" }}';

CREATE TABLE "connect"
(
    "connect" INT
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "09/17/2024" }}';

DROP TABLE "alter";
DROP TABLE "connect";

Related EWIs

No related EWIs.

Known Issues

No issues were found.