{% extends "layout.html" %} {% block content %}

BigQuery Cost Optimization

Cut query cost safely. Keep results the same.

Governor finds expensive dbt patterns, proposes SQL fixes, and validates output before you open a PR.

1) Sync project data

Connect manifest + BigQuery job history.

2) Detect opportunities

Find shuffle spill, slot contention, join explosion, dead columns, and storage issues.

3) Verify before merge

Review diff, dry-run cost impact, and result-equivalence checks.

Detection coverage

Rule-based findings across query, model, and storage behavior.

Safe optimization

Generated SQL with validation report, trust tier, and fallback handling.

PR-ready workflow

Review in app, then ship changes through GitHub PRs.

{% endblock %}