Verify Accuracy of Services Charges Across Service Providers v1.3

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

Billed cost by provider, billing account, billing currency and service, for checking service charges against provider bills. Defaults cover the March 2026 billing period; all populated billing currencies are USD.

Column adaptations (1)

Billed cost by service

Chart controls and notes

Showing the first 20 categories. Open full screen to explore all 95 categories.

Query results
Service provider name	Billing account id	Billing account name	Billing currency	Service name	Total billed cost
AWS	1234567890123	SunBird	USD	Amazon Elastic Compute Cloud	$593.44
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Virtual Machines	$168.24
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure SQL Database	$149.04
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	SQL Database	$108.73
AWS	1234567890123	SunBird	USD	Amazon Relational Database Service	$65.51
Datadog Inc.	1234567890123	SunBird	USD	Datadog	$40.98
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure App Service	$35.98
AWS	1234567890123	SunBird	USD	AmazonCloudWatch	$33.49
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Synapse Analytics	$30.25
AWS	1234567890123	SunBird	USD	Amazon Virtual Private Cloud	$23.15
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Microsoft.Fabric	$19.28
AWS	1234567890123	SunBird	USD	Elastic Load Balancing	$18.17
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Storage Accounts	$17.46
Oracle	20209880	–	USD	COMPUTE	$17.31
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Virtual Network	$13.09
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Load Testing	$10.00
AWS	1234567890123	SunBird	USD	Amazon Elastic File System	$9.54
AWS	1234567890123	SunBird	USD	Amazon Elastic Container Service for Kubernetes	$9.10
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Monitor	$8.75
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Kubernetes Service	$8.36
AWS	1234567890123	SunBird	USD	Amazon Elastic Container Service	$6.70
AWS	1234567890123	SunBird	USD	Amazon Simple Storage Service	$6.62
AWS	1234567890123	SunBird	USD	AWS Config	$5.51
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Machine Learning	$5.05
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Container Instances	$5.02
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure ExpressRoute	$4.19
AWS	1234567890123	SunBird	USD	Amazon CloudFront	$3.86
AWS	1234567890123	SunBird	USD	AWS Lambda	$3.52
Red Hat Inc.	1234567890123	SunBird	USD	Red Hat OpenShift Service on AWS	$3.42
Oracle	20209880	–	USD	OPENSEARCH	$2.60
Oracle	20209880	–	USD	ODSP	$2.49
AWS	1234567890123	SunBird	USD	Amazon ElastiCache	$2.45
AWS	1234567890123	SunBird	USD	Savings Plans for AWS Compute usage	$2.32
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Private Link	$1.85
AWS	1234567890123	SunBird	USD	Amazon DocumentDB (with MongoDB compatibility)	$1.06
Oracle	20209880	–	USD	OKE_CONTROL_PLANE	$0.70
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Microsoft Defender for Cloud	$0.65
AWS	1234567890123	SunBird	USD	AWS Key Management Service	$0.53
AWS	1234567890123	SunBird	USD	Amazon Elastic Container Registry Public	$0.52
AWS	1234567890123	SunBird	USD	Amazon GuardDuty	$0.43
AWS	1234567890123	SunBird	USD	AWS Security Hub	$0.43
AWS	1234567890123	SunBird	USD	AWS Systems Manager	$0.42
AWS	1234567890123	SunBird	USD	Amazon Lightsail	$0.34
AWS	1234567890123	SunBird	USD	AWS Transfer Family	$0.30
AWS	1234567890123	SunBird	USD	Amazon EC2 Container Registry (ECR)	$0.27
Oracle	20209880	–	USD	BLOCK_STORAGE	$0.27
AWS	1234567890123	SunBird	USD	Amazon OpenSearch Service	$0.24
AWS	1234567890123	SunBird	USD	Amazon Simple Queue Service	$0.22
AWS	1234567890123	SunBird	USD	Amazon DynamoDB	$0.22
AWS	1234567890123	SunBird	USD	AWS WAF	$0.21
AWS	1234567890123	SunBird	USD	AWS Secrets Manager	$0.20
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Container Registry	$0.17
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Site Recovery	$0.16
AWS	1234567890123	SunBird	USD	AWS Step Functions	$0.16
AWS	1234567890123	SunBird	USD	Amazon API Gateway	$0.13
Oracle	20209880	–	USD	ORALB	$0.11
AWS	1234567890123	SunBird	USD	Amazon Simple Email Service	$0.07
Oracle	20209880	–	USD	IDENTITY_AND_ACCESS_MANAGEMENT	$0.06
AWS	1234567890123	SunBird	USD	AmazonWorkMail	$0.04
AWS	1234567890123	SunBird	USD	AWS Backup	$0.03
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Key Vault	$0.02
AWS	1234567890123	SunBird	USD	CloudWatch Events	$0.02
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure DNS	$0.02
AWS	1234567890123	SunBird	USD	AWS App Runner	$0.00658
AWS	1234567890123	SunBird	USD	Amazon Route 53	$0.00381
AWS	1234567890123	SunBird	USD	AWS X-Ray	$0.0037
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Application Gateway	$0.00146
AWS	1234567890123	SunBird	USD	AWS CloudTrail	$0.000402
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Logic Apps	$0.00025
AWS	1234567890123	SunBird	USD	Amazon Redshift	$0.00018
AWS	1234567890123	SunBird	USD	Amazon Simple Notification Service	$0.0000853
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Event Grid	$0.0000726
Oracle	20209880	–	USD	ORACLE_STREAMING_SERVICE	$0.0000538
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Data Factory	$0.00003
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Service Bus	$0.00000205
AWS	1234567890123	SunBird	USD	Amazon Glacier	$0.000000574
Oracle	20209880	–	USD	FILESTORAGESERVICE	$0.00000000002
AWS	1234567890123	SunBird	USD	Amazon DevOps Guru	$0.00
AWS	1234567890123	SunBird	USD	Amazon Location Service	$0.00
AWS	1234567890123	SunBird	USD	Amazon QuickSight	$0.00
AWS	1234567890123	SunBird	USD	Amazon WorkDocs	$0.00
AWS	1234567890123	SunBird	USD	AWS CloudFormation	$0.00
AWS	1234567890123	SunBird	USD	AWS Glue	$0.00
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	App Configuration	$0.00
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure File Sync	$0.00
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Savings Plan for Compute	$0.00
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	SQL Managed Instance	$0.00
Oracle	20209880	–	USD	NETWORK	$0.00
Oracle	20209880	–	USD	OBJECTSTORE	$0.00
Oracle	20209880	–	–	OBJECTSTORE	$0.00
Oracle	20209880	–	–	ORACLE_STREAMING_SERVICE	$0.00
Oracle	20209880	–	USD	TELEMETRY	$0.00
AWS	1234567890123	SunBird	USD	AWS Data Transfer	-$0.00957
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure Data Factory v2	-$0.04
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Load Balancer	-$1.39
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Azure DB for MySQL	-$4.89
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	Virtual Machine Scale Sets	-$12.76

97 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_account_id,
       billing_account_name,
       billing_currency,
       service_name,
       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, 4, 5
order by total_billed_cost desc nulls last, service_provider_name, billing_account_id, service_name
limit 500

Parameters: $1 = billing_period_start, $2 = billing_period_end

Original FOCUS SQL

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