What’s In the Lake

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.

The zine

What's In the Lake one-page zine preview
The front map: Bronze, Silver, Gold, and the governance spine — each box a real schema, with the complete live schema (every view, every column) on the reverse.

Cincinnati & Hamilton County Public Library · concept zine series #5 · dbt › medallion › roadmap › schemas › retention · schemas v1.1.1 · 2026-06