Reserved Keywords

Reserved keywords translation for Redshift

circle-info

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentationarrow-up-right

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected]envelope.

Thank you for your understanding.

Description

In Redshift you can use some of the Snowflake reserved keywordsarrow-up-right 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.

circle-info

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.arrow-up-right

Sample Source Patterns

Input Code:

IN -> Redshift_01.sql
CREATE TABLE alter
(
    alter INT
);

CREATE TABLE CONNECT
(
    CONNECT INT
);

DROP TABLE alter;
DROP TABLE CONNECT;

Output Code:

No related EWIs.

Known Issues

No issues were found.

Last updated