Pipeline Patterns mark Subscribe

Resources

Field guides and tools.

Resources for understanding how analytical data systems actually work — then using that understanding to build trusted pipelines and decompose fragile legacy ones.

01 · Field guide

The Modern Cloud Warehouse Modeling Guide

A field guide to trustworthy analytical SQL models.

Learn how to reason about grain, fan-outs, SCD2 joins, window-function grain shifts, nested data explosions, deduplication, incremental drift, tests, and review contracts. Includes an offline HTML reader, BigQuery exercises, practice questions, expected outputs, and bonus review tools.

02 · Free tool

Table Image Generator

Paste a table, get a crisp branded image.

A lightweight browser tool for turning CSV, TSV, and markdown-style tables into polished PNG images for Substack, LinkedIn, Medium, presentations, and technical teaching materials.