MSCEWI2080

Non-literal delimiters with spaces need their backslash scaped in snowflake

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
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI2079

MSCEWI2081

Last modified 2mo ago