Update budgets with billed costs v1.3

Source: FOCUS 1.0 sample
Result rows: 5
Status: Adapted to v1.0
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Actual billed cost per service provider and billing period for updating budgets. Defaults select the March 2026 billing period (the end bound is strict, so April 2 includes periods ending April 1).

Column adaptations (1)

Billed cost by provider and period

Query results
Service provider name	Billing period start	Billing period end	Total billed cost
AWS	2026-03-01	2026-04-01	$789.21
Microsoft	2026-03-01	2026-04-01	$567.21
Datadog Inc.	2026-03-01	2026-04-01	$40.98
Oracle	2026-03-01	2026-04-01	$23.53
Red Hat Inc.	2026-03-01	2026-04-01	$3.42

5 rows. Scroll inside the table to see more.

Precomputed result

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_provider_name,
       billing_period_start,
       billing_period_end,
       sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
  and billing_period_end < $2::timestamptz
group by 1, 2, 3
order by billing_period_start, total_billed_cost desc nulls last, service_provider_name
limit 500

Parameters: $1 = billing_period_start, $2 = billing_period_end

Original FOCUS SQL

SELECT
  ServiceProviderName,
  BillingPeriodStart,
  BillingPeriodEnd,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
  ServiceProviderName,
  BillingPeriodStart,
  BillingPeriodEnd