Global masking rule along with Semantic Types allows you to do this. It’s similar to the iptables where you configure an ordered
rule list. The first matching rule will be applied. If no rule matches, no Semantic Type will be applied.Workspace Admin and DBA can set global masking rules to mask the data.
Go to Data Access>Global Masking.
Click Add. Click +Add condition or +Add condition group, set Semantic Type and then click Confirm.
Repeat to add more rules.
Combined with Semantic Types, here is the result you will get in SQL Editor.