Add a Source Freshness Check

A team needs freshness check implementation for a dashboard that refreshes every morning, but the current path mixes raw ingestion, business rules, and presentation filters in one SQL file. Separate source truth, modeled contract, automated checks, and stakeholder communication. The common trap is to fix the visible dashboard symptom while leaving the upstream assumption implicit, which makes the same incident recur with a different column name. 1. State the consumer promise Write one sentence: this model serves which decision, at what freshness, and at what row grain. This prevents accidental scope creep and gives tests a target. 2. Isolate the…

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in