List all billing and sub-accounts with charges in the period, showing service provider, account ID, name, and type. This list allows practitioners to map entity hierarchies and allocate costs.
Column names from the source use case.
5 rows. Scroll inside the table to see more.
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_account_id,
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 1, 2, 3
order by sub_account_count desc, service_provider_name, billing_account_id
limit 500SELECT DISTINCT
ServiceProviderName,
BillingAccountID,
BillingAccountName,
BillingAccountType
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?