SQL Transformation: PII/PHI Masking

How to mask sensitive information?

:white_check_mark: ANSWER

You can write something like this:

You can also use a one-way crypto hash function such as SHA256(), md5, or others on the input field. Once applied, Rockset only stores the hashed value and not the original PII/PHI field.

Reference for PII/PHI Masking