MSC-BQ0012

Escape Sequence is not valid in Snowflake.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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

BigQuery

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

Snowflake

SELECT
--** MSC-WARNING - MSC-BQ0012 - ESCAPE SEQUENCE \a IS NOT VALID IN SNOWFLAKE. **
'\a';

SELECT
--** MSC-WARNING - MSC-BQ0013 - ESCAPE SEQUENCE \v IS NOT VALID IN SNOWFLAKE. **
'\v';

Recommendations

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