Optimize BigQuery compute slot costs
optimize-model-computeskillsetup L3★381
majiayu000/claude-skill-registry ↗What it does
Assign BigQuery Dataform actions to slot reservations by priority
Best for
Balancing predictable SLA-critical workloads (reserved) with cost-flexible ad-hoc queries (on-demand).
Inputs
- · _reservations.js config with action/reservation mappings
- · priority tier (reserved vs on-demand)
Outputs
- · updated _reservations.js with autoAssignActions call
- · cost vs priority tradeoff analysis
Requires
- · BigQuery slot reservations
- · Dataform
- · @masthead-data/dataform-package
Preconditions
- · _reservations.js exists in definitions/
- · BigQuery reservation paths known
- · dataform compile works
Failure modes
- · Duplicate action assignments
- · Invalid reservation path
- · Dataform compile failure
Trust signals
- · Decision matrix (priority/frequency/cost/impact)
- · File execution order (_prefix)
- · No per-file edits needed