Q:

How to do dynamic regex matching, in redshift? 

So, I have a table with one of columns(say A) a "string", and another column having the corresponding "regex pattern", is it possible to check if the regex matches string value in column A for every column in the table dynamically?  If not, is there any other tool which I can integrate with redshift to do dynamic regex matching? 

A:

So, I found a work around for this, turns out there is no way you can do a dynamic regex matching in redshift, but you can achieve this using python UDF, one of the features aws redshift cluster provides.