Understand the billing account or sub account entity

This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.

Personas: Finance, FinOps Practitioner, Leadership
Capabilities: Invoicing & Chargeback, Planning & Estimating, Reporting & Analytics, Allocation

Understand the Billing Account or Sub Account Entity

Adapted to v1.0

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

Lists the billing accounts with charges in the window, with how many sub accounts each contains and their billed cost, to map the account hierarchy. BillingAccountType (v1.2) does not exist in v1.0 and is omitted; Oracle and Google Cloud billing accounts have no name in the sample.

Column adaptations (1)

Sub accounts per billing account

Query results
Provider name	Billing account id	Billing account name	Sub account count	Total billed cost
AWS	1234567890123	SunBird	86	$833.61
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	11	$567.21
Oracle	20209880	–	4	$26.08
Google Cloud	00DD8H-A57456-A2H965	–	1	$0.02

4 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 provider_name as provider_name,
       billing_account_id as billing_account_id,
       billing_account_name as billing_account_name,
       count(distinct sub_account_id) as sub_account_count,
       sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
  and charge_period_end < $2::timestamptz
group by provider_name, billing_account_id, billing_account_name
order by sub_account_count desc, provider_name, billing_account_id
limit 500

Parameters: $1 = period_start, $2 = period_end

Original FOCUS SQL

SELECT DISTINCT
    ProviderName,
    BillingAccountID,
    BillingAccountName,
    BillingAccountType
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗