QUOTE_IDENT

String function

Description

The QUOTE_IDENT function returns the specified string as a string with a leading double quotation mark and a trailing double quotation mark. (RedShift SQL Language References QUOTE_IDENT function).

To replicated the functionality of this function, it is converted to a CONCAT function.

Grammar Syntax

QUOTE_IDENT(string)

This function is fully supported by Snowflake.

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

SELECT 
    QUOTE_IDENT('"CAT"'),
    "QUOTE_IDENT"('Foo bar') ;

Results

quote_ident	quote_ident
"""CAT"""	"Foo bar"""

Output Code:

Snowflake

OUT -> Redshift_01.sql

SELECT
    CONCAT('"', REPLACE('"CAT"', '"', '""'), '"'),
    CONCAT('"', REPLACE('Foo bar', '"', '""'), '"');

Results

quote_ident	quote_ident
"""CAT"""	"Foo bar"""

Known Issues

No issues were found.

Related EWIs

There are no known issues.