FOCUSExplorer
Queries
Read-only sample

FOCUS 1.0 billing data. Reference snapshots are dated on each page.

Identify Sources of Billed Cost

Inspect the result, its parameters and the SQL behind it.

← All queries
Source
FOCUS use-case library
Data
FOCUS 1.0 sample
Status
Adapted to v1.0
Mode
Read-only
Library snapshot (UTC)
2026-10-08
Source
FOCUS 1.0 sample
Result rows
9
Status
Adapted to v1.0
Execution
PrecomputedRead-only
Result snapshot (UTC)
2026-10-11

Billed cost by provider, publisher and invoice issuer to separate direct, marketplace and reseller spend. v1.0 has no InvoiceId, so billing account and billing period stand in for the invoice. The sample shows AWS Marketplace publishers (Datadog, Red Hat) and several AWS invoicing entities.

Column adaptations (1)
  • InvoiceId → invoice_issuer_name, billing_account_id, billing_period_start: InvoiceId (v1.2+) is absent from v1.0. By definition an invoice covers one billing account's charges for one billing period from one invoice issuer, so that triple is used as an invoice proxy; it is not a real invoice number.

Billed cost by publisher and invoice issuer

Query results
Provider namePublisher nameInvoice issuer nameBilling account idBilling period startTotal billed cost
AWSAmazon Web Services, Inc.Amazon Web Services, Inc.12345678901232026-03-01$768.86
MicrosoftMicrosoftMicrosoft/providers/Microsoft.Billing/billingAccounts/86115372026-03-01$567.21
AWSDatadog Inc.Amazon Web Services, Inc.12345678901232026-03-01$40.98
OracleOracleOracle202098802026-03-01$23.53
AWSAmazon Web Services Canada, Inc.Amazon Web Services Canada, Inc.12345678901232026-03-01$12.97
AWSAmazon Web Services EMEA SARLAmazon Web Services EMEA SARL12345678901232026-03-01$7.37
AWSRed Hat Inc.Amazon Web Services, Inc.12345678901232026-03-01$3.42
OracleOracleOracle202098802026-04-01$2.55
Microsoft–Microsoft/providers/Microsoft.Billing/billingAccounts/86115372026-03-01$0.00

9 rows. Scroll inside the table to see more.

Precomputed result

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select provider_name,
       publisher_name,
       invoice_issuer_name,
       billing_account_id,
       billing_period_start,
       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, 4, 5
order by total_billed_cost desc nulls last, provider_name, publisher_name, invoice_issuer_name, billing_account_id
limit 500

Parameters: $1 = period_start, $2 = period_end

Original FOCUS SQL

SELECT 
    ProviderName,
    PublisherName,
    InvoiceIssuerName,
    InvoiceId,
    SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
    ProviderName,
    PublisherName,
    InvoiceIssuerName,
    InvoiceId