Tutorvo

Data Freshness & SLA Breaches: Now − Last Load

Lesson 3 of 815 minLab

This lesson is part of the course

In this lesson

You measure how old eight Kestrel Goods warehouse tables are, compare each age with its freshness SLA, compute the hours over SLA and count the breaches.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. Run Durations: Minutes from Timestamps, Median & p95Lab15 min Locked
  2. Throughput: Rows per Second, GB per Hour & Backfill TimeLab15 min Locked
  3. Data Freshness & SLA Breaches: Now − Last LoadLab15 min Locked
  4. Failure Rate & Retries: First Attempt, Recovery & Final SuccessLab15 min Locked
  5. Backlog & Catch-Up Time after an OutageLab15 min Locked
  6. Storage Growth & Partition SizingLab15 min Locked
  7. Compute Cost per Run & per TB ProcessedLab15 min Locked
  8. Data Quality Dashboard: Null Rates, Duplicates & Row-Count ReconciliationLab20 min Locked