Sensitive / PII Data
Remove or mask sensitive data from Select Star while still making use of all its features.
Last updated
Was this helpful?
Remove or mask sensitive data from Select Star while still making use of all its features.
Last updated
Was this helpful?
Currently, all Select Star users are able to see the same metadata descriptions and query history Select Star has processed.
You can remove any sensitive or values from Select Star with a PII .
PII is a special tag in Select Star, where the value will be removed in-memory from SQL queries where they are exposed.
To be sure you are tagging all columns sources, click on the database in the left sidebar. Change the Data Type filter to Columns, and use Cmd/Ctrl+F to filter the results to find the columns you're looking for. You can then bulk select columns and tag them as PII.
It is possible to write a query which shows PII directly, such as SELECT * FROM customers c WHERE c.ssn = '555 66 7777'. In Selct Star, any queries using data with the PII tag will be masked as shown.
