optimize-model-compute

What problem does it solve?

This Skill helps manage and optimize BigQuery compute costs by intelligently assigning Dataform actions to either reserved slots or on-demand pricing tiers.

Core Features & Use Cases

• Cost Optimization: Routes workloads to the most cost-effective compute option based on priority and usage patterns.
• Resource Allocation: Assigns critical, high-priority workloads to reserved slots for guaranteed performance.
• Flexibility: Utilizes on-demand pricing for lower-priority or ad-hoc tasks, reducing unnecessary reserved capacity usage.
• Use Case: Ensure your core reporting pipelines always have dedicated compute resources by assigning them to a reservation, while less critical data exploration tasks run on-demand.

Quick Start

Update the reservations configuration in definitions/_reservations.js to assign the model httparchive.reports.tech_summary to the reservation tier.