BigQuery spend analysis for {{ date_range.display }}
Total Spend
INFORMATION_SCHEMA.JOBS during the selected time period.
{{ project_kpis.total_spend }}
Build Spend
build.
{{ project_kpis.build_spend }}
Consumption Spend
consumption.
{{ project_kpis.consumption_spend }}
Storage Monthly
{{ project_kpis.storage_monthly_cost }}
{% else %}No snapshot
{% endif %}Opportunities
{{ "{:,}".format(project_kpis.opportunity_count | default(0)) }}
Estimated Savings
{{ project_kpis.possible_savings | default('$0.00', true) }}
{% if project_kpis.total_spend_raw and project_kpis.total_spend_raw > 0 and project_kpis.possible_savings_raw and project_kpis.possible_savings_raw > 0 %} {% else %} {% endif %}Verified Savings
{{ project_kpis.verified_savings }}
{% if project_kpis.total_spend_raw and project_kpis.total_spend_raw > 0 and project_kpis.verified_savings_raw and project_kpis.verified_savings_raw > 0 %} {% else %} {% endif %}No {{ selected_lens_label | lower }} trend data available for this period
Opportunities
Legend
Monthly Cost
{{ storage_summary.total_monthly_cost | format_usd }}
Savings Available
{{ storage_summary.total_potential_savings | format_usd }}
Datasets
{{ storage_summary.dataset_count }}
Logical Size
{% set gb = storage_summary.total_logical_bytes / 1000000000 %} {% if gb >= 1000 %}{{ "%.1f"|format(gb / 1000) }} TB{% else %}{{ "%.1f"|format(gb) }} GB{% endif %}
{% if selected_lens == 'build' %}Build Jobs / Day{% elif selected_lens == 'consumption' %}Consumption Jobs / Day{% else %}Runs / Day{% endif %}
Bytes / Day
Slots / Day
No {{ selected_lens_label | lower }} usage data available for this period