Complex~38min

The Silent Migration

The v2 API shipped March 1st. Error rate: 2.0% — identical to v1. SLA is green. Platform team is moving on. Someone in mobile support sent a note saying users are complaining about the app "freezing". Investigate.

Tables you'll query

deploymentsclient_appsapi_requestserror_events

What you'll learn

CTEs (WITH clause)Window FunctionsAggregations & GROUP BYDate & Time Functions
Investigate this case →