Analyze cost by participating entities

Personas: Finance, FinOps Practitioner
Capabilities: Budgeting, Forecasting, Invoicing & Chargeback, Planning & Estimating, Reporting & Analytics

Analyze Cost by Participating Entities

Adapted to v1.0

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

Breaks billed cost down by the entities participating in each charge (service provider, invoice issuer, host provider) per service and billing period. ServiceProviderName (v1.3+) is derived from provider_name, or publisher_name for marketplace sellers. HostProviderName uses provider_name, the platform the charge was bought through; for SaaS marketplace sellers such as Datadog the real infrastructure host is not recorded in v1.0.

Column adaptations (2)

Billed cost by service and service provider

Chart controls and notes

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

Query results
Billing period start	Billing period end	Service provider name	Invoice issuer name	Host provider name	Service name	Billing currency	Total billed cost
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Elastic Compute Cloud	USD	$583.31
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Virtual Machines	USD	$168.24
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure SQL Database	USD	$149.04
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	SQL Database	USD	$108.73
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Relational Database Service	USD	$63.94
2026-03-01	2026-04-01	Datadog Inc.	Amazon Web Services, Inc.	AWS	Datadog	USD	$40.98
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure App Service	USD	$35.98
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AmazonCloudWatch	USD	$32.57
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure Synapse Analytics	USD	$30.25
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Virtual Private Cloud	USD	$22.42
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Microsoft.Fabric	USD	$19.28
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Storage Accounts	USD	$17.46
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Elastic Load Balancing	USD	$17.40
2026-03-01	2026-04-01	Oracle	Oracle	Oracle	COMPUTE	USD	$17.31
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Virtual Network	USD	$13.09
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure Load Testing	USD	$10.00
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure Monitor	USD	$8.75
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure Kubernetes Service	USD	$8.36
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Elastic File System	USD	$7.00
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Elastic Container Service for Kubernetes	USD	$6.70
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Elastic Container Service	USD	$6.70
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	Amazon Elastic Compute Cloud	USD	$6.50
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Simple Storage Service	USD	$6.36
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS Config	USD	$5.51
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure Machine Learning	USD	$5.05
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure Container Instances	USD	$5.02
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure ExpressRoute	USD	$4.19
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	Amazon Elastic Compute Cloud	USD	$3.63
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS Lambda	USD	$3.52
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon CloudFront	USD	$3.49
2026-03-01	2026-04-01	Red Hat Inc.	Amazon Web Services, Inc.	AWS	Red Hat OpenShift Service on AWS	USD	$3.42
2026-03-01	2026-04-01	Oracle	Oracle	Oracle	OPENSEARCH	USD	$2.60
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	Amazon Elastic File System	USD	$2.54
2026-03-01	2026-04-01	Oracle	Oracle	Oracle	ODSP	USD	$2.49
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon ElastiCache	USD	$2.45
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	Amazon Elastic Container Service for Kubernetes	USD	$2.40
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Savings Plans for AWS Compute usage	USD	$2.32
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure Private Link	USD	$1.85
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	Amazon Relational Database Service	USD	$1.57
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon DocumentDB (with MongoDB compatibility)	USD	$1.06
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	AmazonCloudWatch	USD	$0.85
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	Elastic Load Balancing	USD	$0.74
2026-03-01	2026-04-01	Oracle	Oracle	Oracle	OKE_CONTROL_PLANE	USD	$0.70
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Microsoft Defender for Cloud	USD	$0.65
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	Amazon Virtual Private Cloud	USD	$0.61
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Elastic Container Registry Public	USD	$0.52
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon GuardDuty	USD	$0.43
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS Security Hub	USD	$0.43
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS Systems Manager	USD	$0.42
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	Amazon CloudFront	USD	$0.37
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	Amazon Lightsail	USD	$0.34
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS Transfer Family	USD	$0.30
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon EC2 Container Registry (ECR)	USD	$0.27
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS Key Management Service	USD	$0.27
2026-03-01	2026-04-01	Oracle	Oracle	Oracle	BLOCK_STORAGE	USD	$0.27
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	Amazon Simple Storage Service	USD	$0.26
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	AWS Key Management Service	USD	$0.25
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon OpenSearch Service	USD	$0.24
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Simple Queue Service	USD	$0.22
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon DynamoDB	USD	$0.22
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS WAF	USD	$0.21
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure Container Registry	USD	$0.17
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS Secrets Manager	USD	$0.16
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure Site Recovery	USD	$0.16
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS Step Functions	USD	$0.16
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon API Gateway	USD	$0.13
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	Amazon Virtual Private Cloud	USD	$0.12
2026-03-01	2026-04-01	Oracle	Oracle	Oracle	ORALB	USD	$0.11
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	AmazonCloudWatch	USD	$0.07
2026-03-01	2026-04-01	Oracle	Oracle	Oracle	IDENTITY_AND_ACCESS_MANAGEMENT	USD	$0.06
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Simple Email Service	USD	$0.06
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AmazonWorkMail	USD	$0.04
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	AWS Secrets Manager	USD	$0.04
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS Backup	USD	$0.03
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	Elastic Load Balancing	USD	$0.03
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Key Vault	USD	$0.02
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	CloudWatch Events	USD	$0.02
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure DNS	USD	$0.02
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	Amazon Simple Email Service	USD	$0.01
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	AWS App Runner	USD	$0.00658
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS X-Ray	USD	$0.0037
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Route 53	USD	$0.00361
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Application Gateway	USD	$0.00146
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	Amazon Elastic File System	USD	$0.000798
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	Amazon Simple Queue Service	USD	$0.000783
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	AWS CloudTrail	USD	$0.000402
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Logic Apps	USD	$0.00025
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	Amazon Route 53	USD	$0.0002
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Redshift	USD	$0.00018
2026-03-01	2026-04-01	AWS	Amazon Web Services EMEA SARL	AWS	Amazon EC2 Container Registry (ECR)	USD	$0.000106
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Simple Notification Service	USD	$0.0000853
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Event Grid	USD	$0.0000726
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	Amazon Simple Storage Service	USD	$0.000061
2026-03-01	2026-04-01	Oracle	Oracle	Oracle	ORACLE_STREAMING_SERVICE	USD	$0.0000538
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Azure Data Factory	USD	$0.00003
2026-03-01	2026-04-01	Microsoft	Microsoft	Microsoft	Service Bus	USD	$0.00000205
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon Glacier	USD	$0.000000574
2026-03-01	2026-04-01	Oracle	Oracle	Oracle	FILESTORAGESERVICE	USD	$0.00000000002
2026-03-01	2026-04-01	AWS	Amazon Web Services, Inc.	AWS	Amazon DevOps Guru	USD	$0.00
2026-03-01	2026-04-01	AWS	Amazon Web Services Canada, Inc.	AWS	Amazon DynamoDB	USD	$0.00

Showing 100 of 120 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 billing_period_start as billing_period_start,
       billing_period_end as billing_period_end,
       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,
       invoice_issuer_name as invoice_issuer_name,
       provider_name as host_provider_name,
       service_name as service_name,
       billing_currency as billing_currency,
       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 billing_period_start, billing_period_end, 3, invoice_issuer_name, provider_name, service_name, billing_currency
order by total_billed_cost desc nulls last, service_provider_name, service_name
limit 500

Parameters: $1 = billing_period_start, $2 = billing_period_end

Original FOCUS SQL

SELECT
  BillingPeriodStart,
  BillingPeriodEnd,
  ServiceProviderName,
  InvoiceIssuerName,
  HostProviderName,
  ServiceName,
  BillingCurrency,
  SUM(BilledCost) AS TotalBilledCost
 FROM focus_data_table
 WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
 GROUP BY
  BillingPeriodStart,
  BillingPeriodEnd,
  ServiceProviderName,
  InvoiceIssuerName,
  HostProviderName,
  ServiceName,
  BillingCurrency
 ORDER BY TotalBilledCost DESC

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗