The Amazon Redshift CONCAT function can be used to combine columns. You can also use the concatenate operator (| |) to join expressions.