In my RedShift SQL data I have to combine 2 fields in order to build unique relationship keys (yep, I know) like so:
toString([account_id]) + toString([program_id])
I need to insert a delimiter between the fields but this won't work:
toString([account_id]) + "_" + toString([program_id])
Throws a parse error: "The identifier '"_"' does not refer to a column, table or property".
Can anyone tell me how to do this?
Please sign in to leave a comment.