Regular Expressions on Synapse

Regular expressions are not supported natively by Synapse. If your Hyper-Q & Synapse environment is running workloads containing regular expression functions, such as REGEXP_REPLACE, for example, these are supported by bespoke UDFs implementing the specific patterns used in the regular expressions that were in scope during the implementation. Any pattern other than these are not supported and need to be addressed using one of the following options:

1. avoid using the pattern and modify the query or view to not use the regular expression functionality
2. implement the pattern by adding respective logic to one or more of the bespoke UDFs implementing the supported patterns in your environment

Please contact your Datometry representative if you want to extend your implementation (Option 2).