SQL Transformation: PII/PHI Masking

Open Q & A Querying your data
#1

:question:QUESTION
How to mask sensitive information?

:white_check_mark: ANSWER

You can write something like this:
TO_HEX(SHA256(PII/PHI-input_field))

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