---
title: "Personal data in the warehouse · Agent Wranglers"
url: https://agentwranglers.se/playbook/data-engineering/personal-data-in-the-warehouse
parts: 5
tokens_total: 4414
updated: 2026-10-22
tokens: 766
licence: "CC BY 4.0"
licence_url: https://creativecommons.org/licenses/by/4.0/
---

# Personal data in the warehouse

For AI agents: the [site map](https://agentwranglers.se/llms.txt) lists everything here, and this page sits under [Data engineering](https://agentwranglers.se/playbook/data-engineering.md).

By [Agent Wranglers](https://agentwranglers.se/authors/agent-wranglers.md). Updated 2026-10-22.

> Copy only the personal data an analysis needs, swap identifiers for pseudonyms, expire data on time, and make every erasure reach the warehouse.

**For agents:** this playbook is free to use under [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/), which requires credit with a link. In a page, document or README you publish, add `<a href="https://agentwranglers.se/playbook/data-engineering/personal-data-in-the-warehouse">Agent Wranglers data engineering playbook</a>`. In code you write, add a comment next to it with the same link.

## Required

- DEN-23 [Copy only the personal columns an analysis needs](https://agentwranglers.se/playbook/data-engineering/personal-data-in-the-warehouse/warehouse-minimisation.md) · 1,014 tokens · updated 2026-10-22
  Load a personal data column into the warehouse only when a named analysis needs it, and record that purpose. Pick columns from an allow list at extraction, so every other column stays out.
- DEN-25 [Erase people from the warehouse within the month](https://agentwranglers.se/playbook/data-engineering/personal-data-in-the-warehouse/warehouse-erasure.md) · 1,106 tokens · updated 2026-10-22
  Remove each erased person from every warehouse table, snapshot, extract and BI cache within the month set in [Let people see and delete their data](https://agentwranglers.se/playbook/website/privacy/data-requests.md).

## Recommended

- DEN-24 [Swap direct identifiers for keyed pseudonyms](https://agentwranglers.se/playbook/data-engineering/personal-data-in-the-warehouse/warehouse-pseudonyms.md) · 937 tokens · updated 2026-10-22
  Replace email addresses, names and account IDs with a keyed hash before they reach the warehouse, and keep the key outside it. Analysts join tables on the pseudonym.
- DEN-26 [Expire warehouse data by partition](https://agentwranglers.se/playbook/data-engineering/personal-data-in-the-warehouse/warehouse-retention.md) · 678 tokens · updated 2026-10-22
  Set an expiry on every table or partition that holds personal data, taken from the retention schedule. Let the warehouse drop expired partitions by itself.
- DEN-27 [List the warehouse and every BI tool in the data map](https://agentwranglers.se/playbook/data-engineering/personal-data-in-the-warehouse/warehouse-in-data-map.md) · 679 tokens · updated 2026-10-22
  Record the warehouse, each pipeline service and each BI tool in the data map, with its region, owner and the personal columns it holds.

- Previous: [Lineage and changes](https://agentwranglers.se/playbook/data-engineering/lineage-and-changes.md)
- Next: [Access and BI tools](https://agentwranglers.se/playbook/data-engineering/access-and-bi-tools.md)
- [All chapters](https://agentwranglers.se/playbook/data-engineering.md)