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. Also If an object is created using a double-quoted identifier, when referenced in a query or any other SQL statement, the identifier must be specified exactly as created, including the double quotes. For more information please refer to Snowflake identifiers documentation.

Example Code

Input Code:

IN -> Redshift_01.sql

CREATE TABLE alter
(
    alter INT
);

CREATE TABLE CONNECT
(
    CONNECT INT
);

DROP TABLE alter;
DROP TABLE CONNECT;

Output Code:

It is important to emphasize that when a reserved keyword is used in Snowflake it is always transformed with double quotes and in lowercase.

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.