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.

Default parameters use the precomputed result, generated as the read-only focus_reader role.

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

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

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

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