Welcome to Pipeline Patterns

Lasha from Pipeline PatternsOct 22, 2026

Thanks for subscribing. A quick note on what you’ve signed up for.

Pipeline Patterns is a publication about how analytical data systems actually work, and how to use that understanding to build pipelines you can trust or to decompose the legacy ones you can’t.

The cadence is one essay at a time, when there’s something worth sending, not on a schedule.

If you want a place to start, I’d point you to this one:

How BigQuery Actually Executes a Query →

Guide

For a deeper, structured version of the modelling ideas, I wrote: A Field Guide to Trustworthy Analytical SQL Models

It covers the patterns behind analytical models people can trust: grain, joins, fan-out, incremental logic, contracts, measures, review standards, and legacy model decomposition.

The guide is currently $29.

Free tool

I also built a free Table Image Generator for people who publish data content and need clean table visuals. Use the Table Image Generator

About me

I am Lasha Dolenjashvili.

Pipeline Patterns is where I write down the parts of analytics that are easy to miss when you only look at the SQL surface.

The publication is free-led. Essays are free because trust is built by being useful in public.

Paid products support the work and go deeper where a post is not enough.

Subscribe if you want practical essays on analytical systems, written for people who need their data work to hold up in production.

If you ever want to reply to a post with a question, a disagreement, or a topic you’d want to read about, please do. I read every reply.

— Lasha