Which Redshift SQL version / functions are supported?
I'm trying to write query to do a Regex sub string on some text. Beast Mode and Magic ETL have Regex but not Regex sub string. MySQL has the capability but Domo is on version 5.x~. My last option was Redshift SQL.
SELECT SUBSTRING_REGEX("Description", '.*(Red).*') as color from "clothing_db"
The database reported a syntax error: [Amazon](500310) Invalid operation: function substring_regex(character varying, "unknown") does not exist;
The closest function I found in the AWS Redshift documentation to Domo was REGEXP_SUBSTR.
REGEXP_SUBSTR ( source_string, pattern [, position [, occurrence [, parameters ] ] ] )
Can someone point me to some documenation on SUBSTRING_REGEX? Even better if anyone has found a solution for sub string extract with pattern they can share.