snowpark-python icon indicating copy to clipboard operation
snowpark-python copied to clipboard

SNOW-1568022: Add optional parameters argument to Column.regexp and Column.rlike

Open sfc-gh-ncrouch opened this issue 6 months ago • 2 comments

What is the current behavior?

snowflake.snowpark.Column.regexp and its alias snowflake.snowpark.Column.rlike both have a signature of Column.regexp(pattern: Union[Column, str]) but the SQL REGEXP also accepts the optional argument parameters: Union[Column, str].

What is the desired behavior?

Optional argument parameters added to Python API.

How would this improve snowflake-snowpark-python?

Add easy access to case-sensitivity controls, multi-line mode and sub-match extraction

References, Other Background

https://docs.snowflake.com/en/sql-reference/functions/rlike

sfc-gh-ncrouch avatar Jul 31 '24 19:07 sfc-gh-ncrouch