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:
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.
Related EWIs
No related EWIs.
Last updated