PII
is a special tag in Select Star, where the value will be removed in-memory from SQL queries where they are exposed.Cmd/Ctrl+F
to filter the results to find the column you're looking for.As Is
. This means it is possible to write a query which shows PII directly, such as SELECT * FROM customers c WHERE c.ssn = '555 66 7777'
.PII
tag.PII
tag will be masked as shown.