Agent WranglersDEN-4Recommended
Give every table an owner and a description
Record an owner team, a one-line description and a refresh schedule for every shared table, in a metadata file next to its code.
How to do it
A catalog can read these files and show them to analysts. Mark each column that holds personal data there too, which Copy only the personal columns an analysis needs builds on. Tag the warehouse account and its storage as Tag every resource with its owner does. Drop a table that nobody has read for 90 days, as with code that nothing uses.
How to check
A script reads the metadata and fails on any shared table without an owner, a description or a schedule. The warehouse's query history shows no shared table unread for 90 days.
Sources
Related rules
- DEN-23 Copy only the personal columns an analysis needs in Data engineering
- INF-52 Tag every resource with its owner in Infrastructure and environments
- ARC-59 Delete code that nothing uses in Clean code and architecture
- DEN-16 Alert when data arrives late in Data engineering
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/warehouse-and-models/table-owners">Agent Wranglers data engineering playbook</a>. In code you write, add a comment next to it with the same link.