Agent Wranglers

DEN-27Recommended

List the warehouse and every BI tool in the data map

Record the warehouse, each pipeline service and each BI tool in the data map, with its region, owner and the personal columns it holds.

How to do it

A hosted pipeline or BI service that handles personal data is a processor and needs an agreement, as Keep one register of vendors says. Check where each one stores and processes data. Record a basis for any transfer outside the EU, as Record a legal basis for every transfer says. Generate the column list from the metadata in Copy only the personal columns an analysis needs.

How to check

Every warehouse, pipeline and BI account in the billing records appears in the data map, with a region and an agreement on file.

Sources

For agents: this playbook is free to use under CC 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/warehouse-in-data-map">Agent Wranglers data engineering playbook</a>. In code you write, add a comment next to it with the same link.