Report effective cost of compute

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

Engineers and Engineering Managers want to reduce their billed cost for Compute from a specific provider. In order to do that, they need to know the current rate of commitment-based discounts (without contracted discounts) per type of commitment. This helps to strategize further purchases.

FOCUS SQL Query

SELECT
  CommitmentDiscountType,
  ProviderName,
  ServiceName,
  SubAccountId,
  SubAccountName,
  BillingPeriodStart,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE BillingPeriodStart  >= ? AND BillingPeriodEnd <= ?
  AND ServiceCategory = 'Compute'
GROUP BY
  CommitmentDiscountType,
  ServiceName,
  ProviderName,
  SubAccountId,
  SubAccountName,
  BillingPeriodStart