Analyze marketplace vendors costs

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

FOCUS Versions

v1.0 v1.1 v1.2

Context

FinOps Practitioners want to be able to answer the question: How much are we spending each month on vendor products that were purchased via a Cloud Service Provider’s marketplace?

FOCUS SQL Query

SELECT
  ChargePeriodStart,
  ChargePeriodEnd,
  ProviderName,
  PublisherName,
  InvoiceIssuerName,
  ROUND(SUM(EffectiveCost),2) AS TotalEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ?
  AND InvoiceIssuerName != PublisherName
GROUP BY
  ChargePeriodStart,
  ChargePeriodEnd,
  ProviderName,
  PublisherName,
  InvoiceIssuerName
ORDER BY TotalEffectiveCost ASC