{# Sortable column headers #} {% set exp_cols = [ ('project', 'Project', 'left'), ('table', 'Object', 'left'), ('type', 'Type', 'left'), ('workload', 'Workload', 'left'), ('cost', 'Query Cost', 'right'), ('savings', 'Savings', 'right'), ] %} {% if not local_runtime_mode %} {% set exp_cols = exp_cols + [('occurrence', 'Occurrences', 'right')] %} {% endif %} {% set exp_cols = exp_cols + [('age', 'Last Detected', 'right')] %} {% for col_key, col_label, col_align in exp_cols %} {% endfor %} {% for opp in opportunities %} {% if not local_runtime_mode %} {% endif %} {% endfor %}

{% if col_key in ('cost', 'savings') %} {% if col_key == 'cost' %} Cost from the most recent BigQuery job execution, dry-run estimate, or detection heuristic. {% else %} Estimated per-run savings from solution dry-runs or detection heuristics. {% endif %} {{ col_label }} {% else %} {{ col_label }} {% endif %}	Safe = low risk, apply directly. Review = check changes first. Upstream fix = covered by another model's solution. Generating = in progress. Awaiting = not yet started. State
{{ opp.project_name }}	{{ opp.dbt_model_name if opp.dbt_model_name else (opp.affected_table.split('.')[-1] if '.' in opp.affected_table else opp.affected_table) }}	{{ opp.opportunity_type | replace('_', ' ') }}	{% if opp.query_workload_kind == 'build' %} Build {% elif opp.query_workload_kind == 'consumption' %} Consumption {% elif local_runtime_mode %} Unclassified {% else %} Query {% endif %}	{% if opp.query_cost_value is not none %} {{ opp.query_cost_value | format_usd }} {% else %} — {% endif %}	{% if opp.solution_job_status in ('queued', 'in_progress') %} Generating {% elif opp.solution_job_status == 'failed' %} Failed {% elif opp.possible_savings_value is not none %} ~{{ opp.possible_savings_value | format_usd }} ↓ {% elif opp.optimized_cost_value is not none %} {{ opp.optimized_cost_value | format_usd }} {% if opp.optimized_delta_direction == 'down' %} ↓ {% elif opp.optimized_delta_direction == 'up' %} ↑ {% endif %} {% else %} — {% endif %}	{{ opp.occurrence_count }}	{{ opp.last_detected_at.strftime("%d/%m/%Y") if opp.last_detected_at else (opp.created_at.strftime("%d/%m/%Y") if opp.created_at else "—") }}	{% set rs = opp.recommendation_state %} {% if opp.solution_risk_level == 'low' %} Safe {% elif opp.solution_risk_level == 'medium' %} Review {% elif opp.solution_risk_level == 'high' %} High risk {% elif rs and rs.key == 'generating' %} Generating {% elif rs and rs.key == 'upstream_fix' %} Upstream fix {% elif rs and rs.key == 'failed' %} Failed {% elif rs and rs.key == 'skipped_below_threshold' %} Skipped {% else %} Awaiting {% endif %}