Report service costs by providers subaccount

Source: FOCUS 1.0 sample
Result rows: 64
Status: Runs on sample
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Effective cost per service and charge period for one provider and sub account. The default is the Azure subscription with the highest cost (daily charge periods); the source also ordered by BillingPeriodStart, which is not grouped, so rows are ordered by charge period and cost instead.

Billing period start fromBilling period end beforeSub accountProvider

Daily service cost for the sub account

Query results
Provider name	Service name	Sub account id	Charge period start	Total effective cost
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-01	$0.66
Microsoft	Virtual Network	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-01	$0.10
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-01	$0.0000024
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-02	$9.88
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-02	$0.000144
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-03	$7.03
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-03	$0.00167
Microsoft	Azure SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-04	$33.00
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-04	$9.60
Microsoft	SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-04	$5.53
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-04	$0.66
Microsoft	Virtual Network	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-04	$0.31
Microsoft	SQL Managed Instance	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-04	$0.00
Microsoft	Azure SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-05	$8.50
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-05	$1.17
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-05	$0.02
Microsoft	Logic Apps	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-05	$0.00025
Microsoft	SQL Managed Instance	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-05	$0.00
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-06	$5.06
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-06	$0.0000297
Microsoft	Virtual Network	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-07	$0.12
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-07	$0.05
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-07	$0.04
Microsoft	SQL Managed Instance	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-07	$0.00
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-08	$0.48
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-08	$0.000138
Microsoft	Azure SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-08	$0.00
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-09	$36.21
Microsoft	Azure SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-09	$1.21
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-09	$0.000237
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-10	$0.74
Microsoft	Azure SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-10	$0.46
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-10	$0.0000213
Microsoft	Azure Monitor	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-10	$0.00
Microsoft	Azure SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-11	$7.50
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-11	$0.82
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-11	$0.0000411
Microsoft	SQL Managed Instance	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-11	$0.00
Microsoft	Azure SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-12	$28.50
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-12	$2.04
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-12	$0.01
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-13	$7.23
Microsoft	Virtual Network	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-13	$0.09
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-13	$0.00263
Microsoft	Azure Monitor	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-13	$0.00
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-14	$9.81
Microsoft	Virtual Network	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-14	$0.10
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-14	$0.0000618
Microsoft	SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-15	$8.44
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-15	$7.66
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-15	$0.0000922
Microsoft	SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-16	$29.18
Microsoft	Azure SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-16	$4.21
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-16	$0.0017
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-16	$0.0000597
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-17	$4.75
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-17	$0.0000279
Microsoft	Azure SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-18	$31.50
Microsoft	SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-18	$27.00
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-18	$4.81
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-18	$0.00175
Microsoft	Azure SQL Database	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-19	$4.26
Microsoft	Virtual Machines	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-19	$2.73
Microsoft	Storage Accounts	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	2026-03-19	$0.0000341

64 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,
       service_name as service_name,
       sub_account_id as sub_account_id,
       charge_period_start as charge_period_start,
       sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
  and billing_period_end < $2::timestamptz
  and sub_account_id = $3::text
  and provider_name = $4::text
group by provider_name, service_name, sub_account_id, charge_period_start
order by charge_period_start, total_effective_cost desc nulls last, service_name
limit 500

Parameters: $1 = billing_period_start, $2 = billing_period_end, $3 = sub_account_id, $4 = provider_name

Original FOCUS SQL

SELECT 
  ProviderName,
  ServiceName,
  SubAccountId,
  ChargePeriodStart,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
  AND SubAccountId = ?
  AND ProviderName = ?
GROUP BY 
  ProviderName,
  ServiceName,
  SubAccountId,
  ChargePeriodStart
ORDER BY 
  SUM(EffectiveCost),
  BillingPeriodStart DESC

Provider name

Service name

Sub account id

Charge period start

Total effective cost

Microsoft

Virtual Machines