Cold Case~65min
The Invoice For Compute Instances That Never Existed
CUST-08 was billed for 12 compute instances every month for May, June, and July 2024 — but provisioned_resources shows only 7 distinct instances were ever active in any of those months. The same 5-instance gap, every month, at $85/month each: $1,275.00 in phantom compute billed across the quarter. CUST-15 was billed for 10 instances in May and only 3 were running on any single spot-check day — but counting every distinct instance active at any point that month (a short autoscaling burst added 7 more for a few hours on May 15th) totals exactly 10. The bill matches the month's real usage.
Tables you'll query
customersprovisioned_resourcesinvoice_line_items
What you'll learn
JOINsAggregations & GROUP BYDate & Time Functions