Analyze Cost by Participating Entities

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

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

Virtual Machines

USD

$168.24

2026-03-01

2026-04-01

Microsoft

Azure SQL Database

USD

$149.04

2026-03-01

2026-04-01

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

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

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.Fabric

USD

$19.28

2026-03-01

2026-04-01

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

COMPUTE

USD

$17.31

2026-03-01

2026-04-01

Microsoft

Virtual Network

USD

$13.09

2026-03-01

2026-04-01

Microsoft

Azure Load Testing

USD

$10.00

2026-03-01

2026-04-01

Microsoft

Azure Monitor

USD

$8.75

2026-03-01

2026-04-01

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

Azure Machine Learning

USD

$5.05

2026-03-01

2026-04-01

Microsoft

Azure Container Instances

USD

$5.02

2026-03-01

2026-04-01

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

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

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

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

OKE_CONTROL_PLANE

USD

$0.70

2026-03-01

2026-04-01

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

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

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

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

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

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

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

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

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

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

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_STREAMING_SERVICE

USD

$0.0000538

2026-03-01

2026-04-01

Microsoft

Azure Data Factory

USD

$0.00003

2026-03-01

2026-04-01

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

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

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

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