Sensitive / PII Data

Remove or mask sensitive data from Select Star while still making use of all its features.

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 PII (Personally identifiable information) values from Select Star with a PII Tag.

Video Tutorial: PII & Auto PII Detection

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.

If you need to see the PII data or have tagged something as PII by mistake, remove the tag and the queries will no longer be masked the next time your metadata sync runs.