SSC-EWI-TD0020

Regexp_Substr Function only supports POSIX regular expressions.

This EWI is deprecated, please refer to SSC-EWI-0009 documentation

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

Teradata:

IN -> Teradata_01.sql

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

Snowflake Scripting:

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 [e-mail]