Complex~38min
The Quiet Outage
Weekly uptime: 99.93%. SLA is green. The on-call engineer got a perfect score last month. Three customers emailed on Monday morning saying the app was broken "all weekend." Pull the logs and find out who's right.
Tables you'll query
autoscale_eventsapi_logserror_eventssla_windows
What you'll learn
CTEs (WITH clause)Window FunctionsDate & Time FunctionsAggregations & GROUP BY