Snowflake, Column Level Security, Dynamic Data Masking.
table customer modify column credit_card_number set masking policy card_number_pii; create or replace masking policy dob_pii as (date_of_birth date) returns date -> case when current_role() in ('SYSADMIN') then date_of_birth else '1999-01-01'::date end; alter table customer modify column