propose_fix
Creates a reviewable unified diff or SQL fix for Databricks cost-waste issues—idle clusters, warehouse auto-stop, and Delta maintenance—without applying changes.
Instructions
Propose a fix as a unified diff (Asset Bundle YAML) or reviewable SQL — never applied.
issue: 'all_purpose_job' (move tasks off existing_cluster_id onto a job cluster),
'no_autotermination' (set resources.clusters..autotermination_minutes),
'warehouse_autostop' (set resources.sql_warehouses..auto_stop_mins, default 10),
or Delta (delta_optimize|delta_vacuum|delta_zorder|delta_predictive_optimization|
delta_overfrequent_optimize) which returns SQL (resource_key = catalog.schema.table;
for delta_zorder pass columns as comma-separated node_type_id; for delta_vacuum pass
retention hours as minutes, default 168 / min 7 days). Pass cluster_id from find_waste for
cluster fixes — a deleted cluster is refused. bundle_yaml may be empty for Delta issues.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | No | databricks.yml | |
| issue | Yes | ||
| minutes | No | ||
| cluster_id | No | ||
| bundle_yaml | Yes | ||
| num_workers | No | ||
| node_type_id | No | ||
| resource_key | Yes | ||
| spark_version | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |