{# Audit's object-overview detail page. Lists EVERY active issue + EVERY available SQL-rewrite suggestion for the requested opportunity's destination_table — not just one rule's findings. The cohort view at /jobs/{table} stays as the deep-dive (cost chart, Query versions). PR / dry-run / shadow surfaces are deliberately absent — audit is read-only and never generates solutions. #} {% extends "layout.html" %} {% block content %}
Opportunities › {% if row.dbt_model_name %}{{ row.dbt_model_name }}{% else %}{{ row.affected_object or row.affected_table }}{% endif %}

Recommendation

{% if row.dbt_model_name %}

{{ row.dbt_model_name }}

{% else %}

{{ row.affected_table }}

{% endif %}
{# Aggregate pills: how many issues + how many suggestions this object carries across the whole scan. The exact rule names live in their respective sections below. #} {% if issue_cards | length > 0 %} {{ issue_cards | length }} issue{% if issue_cards | length != 1 %}s{% endif %} {% else %} No issues {% endif %} {% if improvements | length > 0 %} {{ improvements | length }} suggestion{% if improvements | length != 1 %}s{% endif %} {% endif %} {% if row.dbt_model_name %} dbt {% endif %} {% if row.author_email %} {{ row.author_email }} {% endif %}
{% if row.dbt_model_name %}

{{ row.affected_table }}

{% endif %}
{# Stat strip — table-level numbers from the highest-priority opportunity's representative job (issues outrank suggestions). Cost / Bytes Processed / Slot Time describe one execution of the underlying query. The cohort view exposes per-day aggregates if the user needs them. #}
{# Issues-found stat card. Lists issue rule names as plain text (one per line) so users get the failure summary up-top without scrolling. When zero issues fired (suggestion-only object), reads "—" in muted text. #}

Issues found

{% if issue_cards %}
{% for issue in issue_cards %}

{{ issue.row.opportunity_type | replace('_', ' ') }}

{% endfor %}
{% else %}

—

{% endif %}

Cost (this execution)

{{ row.query_cost_value | format_usd }}

Bytes Processed

{% if job and job.total_bytes_processed is not none %}

{{ job.total_bytes_processed | format_bytes }}

{% if job.total_bytes_billed is not none %}

billed: {{ job.total_bytes_billed | format_bytes }}

{% endif %} {% else %}

—

{% endif %}

Slot Time (hours)

{% if job and job.total_slot_ms is not none %}

{{ "%.1f" | format((job.total_slot_ms or 0) / 3600000) }}

{% if job.duration_ms is not none %}

duration: {{ job.duration_ms | format_duration }}

{% endif %} {% else %}

—

{% endif %}
{# Cost trend collapsible. The full job-history cohort view lives at /jobs/{table} — link below the chart. #} {% if chart_points_payload %}
{% set chart_title = "Cost trend for this table" %} {% set chart_subtitle = "Click to expand — one point per day across the scan window. Days without executions are skipped." %} {% set chart_collapsible = true %} {% include "jobs/_cost_chart.html" %}
View full job history (versions + per-version diffs) →
{% endif %} {# Issues found — one bordered card per issue rule that fired on this table. Each card has a 2-column Why-this-fired / Recommended- fix split, so readers can pair the cause with the fix per rule. When a rule has no template SQL diff, Recommended-fix points to the Available improvements section below rather than repeating the Why-this-fired text verbatim. When zero issues fired (suggestion-only object), this section is hidden. #} {% if issue_cards %}

Issues found

Cost / performance signals BigQuery's optimizer attached to this table's executions. Each card lists a single issue rule's evidence + recommended fix.

{% for issue in issue_cards %}
{{ issue.row.opportunity_type | replace('_', ' ') }}

Why this fired

{{ issue.row.explanation }}

{% if issue.rule_meta and issue.rule_meta.description %}

{{ issue.rule_meta.description }}

{% endif %}

Recommended fix

{% if issue.template_result %}

{{ issue.template_result.explanation }}

{% if issue.diff_lines %}

SQL diff in Available improvements below.

{% endif %} {% elif improvements %}

See Available improvements below for the SQL-rewrite catalogue.

{% else %}

This issue type doesn't have a single-query SQL rewrite. The fix is at the workload-scheduling or schema layer.

{% endif %}
{% endfor %}
{% endif %} {# Available improvements — every SQL-rewrite suggestion that fired on any opportunity for this table, deduped by rule_type. Each is a deterministic rewrite (no LLM) and renders inline as its own green/red diff. #} {% if improvements %}

Available improvements

SQL-rewrite suggestions that apply to this object's queries. Applying them won't necessarily resolve any single issue on its own, but each reduces work the query is doing and may move the needle on cost or slot pressure.

{% for imp in improvements %}
{{ imp.display_name }} {% if imp.template_id %} deterministic rewrite {% endif %} {% if imp.occurrences and imp.occurrences > 1 %} ×{{ imp.occurrences }} {% endif %}
{% if imp.explanation %}

{{ imp.explanation }}

{% endif %} {% if imp.diff_lines or imp.before_content %}
{% if imp.after_content %} {% endif %}
{% if imp.diff_lines %} {% set diff_lines = imp.diff_lines %} {% set file_path = imp.template_id %} {% include "components/code_diff.html" %} {% else %}

No diff available — template did not produce a change.

{% endif %}
{% if imp.after_content %} {% endif %}
{% endif %} {% if imp.rollback %}
Rollback instructions

{{ imp.rollback }}

{% endif %}
{% endfor %}

All diffs are generated by deterministic templates (no LLM). Apply each one to {% if row.dbt_model_name %}your dbt model {{ row.dbt_model_name }}{% else %}the source SQL{% endif %} manually.

{% endif %} {# Evidence + BigQuery query lookup — two side-by-side cards on >=lg, stacked on smaller screens. Each card collapses independently. The right-hand card renders the ``INFORMATION_SCHEMA.JOBS_BY_PROJECT`` SELECT pre-filtered by job_id so the user can paste it into the BigQuery console and inspect the row themselves. Evidence + lookup come from the representative opportunity (highest-priority for this table). #} {% if visible_evidence or job_lookup_sql %}
{% if visible_evidence %}

Evidence
{% for key, value in visible_evidence.items() %}
{{ key }}
{% if value is mapping or (value is iterable and value is not string) %} {{ value | tojson }} {% else %} {{ value }} {% endif %}
{% endfor %}
{% endif %} {% if job_lookup_sql %}

BigQuery query

Paste this into the BigQuery console to inspect the underlying job row. 

{{ job_lookup_sql }}
{% endif %}
{% endif %}
{# Generic tab toggler — picks up every ``[data-tab]`` / ``[data-tab-pane]`` pair inside an ancestor with ``[data-active-tab]``. Same script as the cohort page so suggestion cards' Diff / Original SQL tabs work without coupling to the class name. #} {% endblock %}