MSCEWI2080
Non-literal delimiters with spaces need their backslash scaped in snowflake
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Low
Description
SnowConvert indicates that non-literal delimiters with spaces need their backslash scaped in snowflake
Example code
Input code
SELECT NVP('store = whole foods&&store: ?Bristol farms','store', '&&', valueDelimiter, 2);
Output code
SELECT
PUBLIC.NVP_UDF('store = whole foods&&store: ?Bristol farms', 'store', '&&', valueDelimiter, 2) /*** MSC-WARNING - MSCEWI2080 - NON-LITERAL DELIMITERS WITH SPACES NEED THEIR BACKSLASH SCAPED IN SNOWFLAKE ***/ /*** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'NVP_UDF' INSERTED. ***/;
Recommendations
If you need more support, you can email us at [email protected]
Last updated