Hyperlink bug with Redshift connection

[dougverse]

I have a redshift data source that includes two fields: external_url, and external_label. external_url is fully formed https://example.com/id and external_label is a simple string.

I want to make a calculated field, external_hyperlink = HYPERLINK(external_url, external_label)

Every time I do this I get the error:> 

Error with SQL statement: ERROR: function concat(character varying, "unknown", character varying) does not exist

At first I tried doing type conversions before realising there was nothing I could do to fix it. I believe the HYPERLINK function is generating SQL that passes in more than two arguments to the CONCAT function in redshift.

Unfortunately, CONCAT in Redshift only takes two arguments. To have more you need to nest or use the || operator. Redshift CONCAT docs.

Is there any other way to get a clickable link into a table when you have a Redshift source?

Thanks

[dougverse]

I have a workaround that involves building the hyperlink field in a blend, but this is not a good solution as it brings with it all the limitations of blends (not reusable, performance concerns etc). Thought this might be useful for anyone with the same problem.