Determine target of virtual currency usage

This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.

Personas: Engineering, FinOps Practitioner
Capabilities: Allocation, Invoicing & Chargeback, Planning & Estimating, Rate Optimization, Reporting & Analytics

Determine Target of Virtual Currency Usage

Not in v1.0 sample

Source: FOCUS use-case SQL
Status: Not in v1.0 sample
Results: Not run
Mode: Read-only
Library snapshot (UTC): 2026-10-08

PricingCurrency and PricingCurrencyEffectiveCost (introduced in FOCUS v1.2) are absent from the v1.0 sample.

Review the original SQL below and the required columns before using a newer FOCUS dataset.

Original FOCUS SQL

SELECT 
    ProviderName,
    PublisherName,
    ServiceName,
    ChargeDescription,
    SUM(PricingCurrencyEffectiveCost) AS TotalPricingCurrencyEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
AND PricingCurrency = ?
GROUP BY
    ProviderName,
    PublisherName,
    ServiceName,
    ChargeDescription
ORDER BY TotalPricingCurrencyEffectiveCost DESC
LIMIT 10

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗