The shelves, tier by tier — what we keep, today. A companion to the medallion issue — #3 named the three layers; this one shows what actually sits in each. Every box is a real schema in the lake right now.
The front is a curated map — Bronze (catalog, circulation, OpenLibrary), Silver (cleaned &
joined), Gold (ready-to-pull marts), and the Platform spine that logs and validates every load. The back
is the complete live schema: all 17 notable views, every column, with its type —
219 columns in all, generated straight from the lake’s information_schema so it
can’t drift.
Cincinnati & Hamilton County Public Library · concept zine series #5 · dbt › medallion › roadmap › schemas › retention · schemas v1.1.1 · 2026-06