Medallion Architecture Explained: Bronze, Silver, Gold, and Pipeline Delay

The medallion pattern is a solid design for analytics: raw data lands in bronze, silver cleans and conforms it, gold turns it into the aggregates dashboards read. Each hop is a separate transform on its own schedule, so gold is only as fresh as the slowest hop above it. For a dashboard that lag is invisible; for an automated decision that needs context right now, like a fraud check or a credit limit, it means reading a number that already describes the past. This explainer covers the three layers, where the delay comes from, and the alternative for that one workload: read the same events once and refresh derived context incrementally, as often as you need, from one internally coherent snapshot.