Resources

Field notes from the pond.

How we build data platforms, written down: deep-dive case studies, practical guides, and templates you can copy into your own repo.

Latest

Guide

Bronze, Silver, Gold: a medallion setup that survives schema drift

Auto Loader, rescued columns and drift alerts, so a new field upstream never breaks a dashboard downstream.

Coming soon8 min read
Case study

MMM and multi-touch attribution: what we actually ship

A marketing mart on Redshift and dbt that feeds both models, and how the budget team uses the results.

Coming soon10 min read
Template

dbt marketing attribution mart, ready to fork

fct_touchpoints, dim_campaigns and friends, with keys, tests and docs already wired up.

Coming soonGitHub repo
Guide

Hashing PII into a stable user_id with SHA-256

One identity across email, phone and address pools, without storing raw personal data in your marts.

Coming soon6 min read
Notes

Airflow 3 + Cosmos: one dbt model, one task

Why we split dbt runs per model, and what it does to retries, lineage and on-call sleep.

Coming soon5 min read
Case study

An AI analyst on your warehouse, without the hallucinations

Grounding Genie and Claude in tested dbt models and metric definitions so answers match the dashboard.

Coming soon9 min read

Downloads

Steal our templates.

PDF checklist

Data platform readiness

32 questions to answer before you pick a warehouse, from source inventory to who owns each metric.

Get the checklist
Spreadsheet

Metric definitions template

Name, grain, formula, owner and source model for every KPI, so finance and marketing stop arguing.

Get the template
dbt project

Starter project skeleton

Staging, intermediate and marts folders with naming rules, tests and CI checks you can run on day one.

Get the skeleton