Snowflake Dynamic Data Masking Demo to hide Personally Identifiable Information (PII)

#snowflake #datagovernance

Open-sourced here:
https://github.com/allen-wong-tech/snowflake/tree/master/dynamic-data-mask

We demo Snowflake Dynamic Data Masking to hide Personally Identifiable Information (PII). Here's the use case:

Human Resources has the following requirements around Personally Identifiable Information (PII) employee salary data:

A regular employee is allowed to see his/her own data.
A manager can see data related to his/her direct and in-direct reports.
Members of HR can see everybody’s data except other HR people.
Members of Finance can see data rolled up by department.

How can we implement this in Snowflake using Dynamic Data Masking?
How can we also use this to implement Row-Level Security so that users can only see the records they are authorized?
Disclaimer: These are personal posts that don't represent Snowflake.

Видео Snowflake Dynamic Data Masking Demo to hide Personally Identifiable Information (PII) канала Allen Wong