Personal data inventory of the warehouse
This is a team plan, best installed into a shared workspace so everyone with a role in it can see and own their tasks. Most analytics platforms hold more personal data than anyone thinks: email addresses in event payloads, phone numbers in support exports, birth dates in a CRM sync nobody uses.
First tasks
- Export the list of schemas, tables and columns from the warehouse information schema
- Search column names for patterns such as email, phone, address, dob and ip
- Sample 100 rows from each unclear free-text or JSON column
- Tag each personal data column with its data type and source system
- Ask the agent to summarise the inventory into a one-page view by source system