SSC-EWI-BQ0007

Escape Sequence is not valid in Snowflake.

Severity

Low

Description

Bell character (\a) and Vertical character (\v) are valid escape sequences in BigQuery, but not in Snowflake.

This warning is added when a bell character or vertical character escape sequence is found when translating BigQuery code. More about Snowflake Escape Sequences.

Code Example

Input Code:

BigQuery

IN -> BigQuery_01.sql

SELECT "\a";
SELECT "\v";

Output Code:

Snowflake

OUT-> BigQuery_01.sql

SELECT
    !!!RESOLVE EWI!!! /*** SSC-EWI-BQ0007 - ESCAPE SEQUENCE \a IS NOT VALID IN SNOWFLAKE. ***/!!!
    '\a';
SELECT
    !!!RESOLVE EWI!!! /*** SSC-EWI-BQ0007 - ESCAPE SEQUENCE \v IS NOT VALID IN SNOWFLAKE. ***/!!!
    '\v';

Recommendations

• If you need more support, you can email us at [email protected]