Is it possible to read the data from Redshift as it is and then use a successive Expression transformation in the mapping to perform the same regular expression replacement using REG_REPLACE ?
Function support (it should be supported on Spark) -
REG_REPLACE documentation -
Thanks for your answer and sorry for the delay.
Reading the data from Redshhift as it is and using an Expression transformation with REG_REPLACE works when executing in Native mode. However, when running in Spark mode, the rows aren't properly read by the redshift read object and don't even show in a Data Viewer inside the map.
That's why I was trying to treat it in the SELECT statement