SSC-EWI-0009

Regexp_Substr Function only supports POSIX regular expressions.

Severity

Low

Description

Currently, there is no support in Snowflake for extended regular expression beyond the POSIX Basic Regular Expression syntax.

This EWI is added every time a function call to REGEX_SUBSTR, REGEX_REPLACE, or REGEX_INSTR is transformed to SnowFlake to warn the user about possible unsupported regular expressions. Some of the features not supported are lookahead, lookbehind, and non-capturing groups.

Example Code

Input Code:

IN -> Teradata_01.sql

SELECT REGEXP_SUBSTR('qaqequ','q(?=u)', 1, 1);

Output Code:

OUT -> Teradata_01.sql

SELECT
!!!RESOLVE EWI!!! /*** SSC-EWI-0009 - REGEXP_SUBSTR FUNCTION ONLY SUPPORTS POSIX REGULAR EXPRESSIONS ***/!!!
REGEXP_SUBSTR('qaqequ','q(?=u)', 1, 1);

Recommendations

• Check the regular expression used in each case to determine whether it needs manual intervention. More information about expanded regex support and alternatives in SnowFlake can be found here.

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