find_waste
Detect wasted Databricks DBUs over a chosen period across clusters, warehouses, jobs, and Delta tables, then return measured and projected savings, with low-confidence and error flags for review.
Instructions
Find wasted DBUs over the last days days (1..365). Read-only; never changes the workspace.
Returns measured_saving_usd / measured_waste_dbu, observation_days, projected_30d_usd/_dbu
(= measured / observation_days * 30; withheld below 3 days) and low_confidence (< 7 days).
Classic: jobs on all-purpose, clusters with auto-termination off or above
max_autotermination_minutes (default 60), idle/oversized clusters. Serverless: warehouses with
no/long auto-stop, idle warehouses (idle_pct ≥ warehouse_idle_pct, default 80), serverless jobs
incl. failed-run share. Delta: needs OPTIMIZE / VACUUM / over-frequent OPTIMIZE (proposals only).
At most max_rows rows per check (1..1000). USD is None when unknown; failed checks go under
errors with the table and the GRANT/fix — totals are never a fake $0.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | No | ||
| max_rows | No | ||
| warehouse_idle_pct | No | ||
| max_autotermination_minutes | No |