Alright, did some reading up on hashing and it looks like I may have answered my own question (please correct me if I’ve misunderstood).
Looks like no salt prior to R106
Just pass an empty string to the enrichment to designate no salt being passed into the function
Using salt with cryptographic hash functions just adds to the functions’ input, so we just have to add the salt onto the end of the plain text. Below, we can apply our salt “test” to our plaintext input of “hello”:
md5('hellotest') as md5_salt_test,
md5('hello') as md5_no_salt;
There doesn’t seem to be any standard method to applying salt so you have to make sure it matches where you will be using it elsewhere (e.g. hashing old data in SQL Runner). Judging from the enrichment source code, we simply have to append the salt to the string in Redshift to match the salt in Enrichment: