My organization is looking into how SNOW can handle PHI/PII. We would like to identify records that contain PHI and if possible, encrypt/blur the data that is PHI out.
I believe we can handle the first part pretty easily by creating a new field.
We are stuck on how to implement this second part. The data could reside anywhere is the problem. We cannot just create a new field called PHI and then encrypt it if needed. We would want to have the record identified, and if possible, have SNOW read the record and maybe with pattern recognition or something similar, block out some content? (I feel like this last ask is not possible, especially without isolating the PHI data)
