I'd like to encrypt email address in a data extension with SHA256 within marketing cloud. This will be used as a unique identifier.
- When the email goes into a data extension, have the email address in one column but in another column, have the SHA256 encryption generated.
- Once it's there, update all subscribers attribute with this encryption.
- Keep this constant for every subscriber that goes into the data extension.
I'm trying to get some ideas on where to start. Would ssjs be my best option or sql?