Compare Billed Cost per Subaccount to Budget v1.3

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

Returns total usage billed cost for one service provider and sub account in the window, to compare against that sub account's budget. ServiceProviderName (v1.3+) is derived from provider_name, or publisher_name for marketplace sellers. The default sub account is the AWS account with the most usage cost.

Column adaptations (1)

Charge period startCharge period end (inclusive)Service providerSub account

Sub account usage billed cost

$1,430.99

Total billed cost

Query results
Service provider name	Sub account id	Sub account name	Total billed cost
AWS	11353890204	Atlas Orion	$1,430.99

1 row. 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,
       sub_account_id as sub_account_id,
       sub_account_name as sub_account_name,
       sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where charge_category = 'Usage'
  and charge_period_start >= $1::timestamptz
  and charge_period_end <= $2::timestamptz
  and case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end = $3::text
  and sub_account_id = $4::text
group by 1, sub_account_id, sub_account_name
order by total_billed_cost desc nulls last

Parameters: $1 = period_start, $2 = period_end, $3 = service_provider_name, $4 = sub_account_id

Original FOCUS SQL

SELECT
  ServiceProviderName,
  SubAccountId,
  SubAccountName,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargeCategory = 'Usage'
  AND ChargePeriodStart >= ? and ChargePeriodEnd <= ?
  AND ServiceProviderName = ?  
  AND SubAccountId = ?  
GROUP BY
  ServiceProviderName,
  SubAccountId,
  SubAccountName

Service provider name

Sub account id

Sub account name

Total billed cost

AWS

11353890204

Atlas Orion

$1,430.99

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, sub_account_id as sub_account_id, sub_account_name as sub_account_name, sum(billed_cost) as total_billed_cost from focus.cost_and_usage where charge_category = 'Usage' and charge_period_start >= $1::timestamptz and charge_period_end <= $2::timestamptz and case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end = $3::text and sub_account_id = $4::text group by 1, sub_account_id, sub_account_name order by total_billed_cost desc nulls last

SELECT ServiceProviderName, SubAccountId, SubAccountName, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE ChargeCategory = 'Usage' AND ChargePeriodStart >= ? and ChargePeriodEnd <= ? AND ServiceProviderName = ? AND SubAccountId = ? GROUP BY ServiceProviderName, SubAccountId, SubAccountName