Analyze costs of components of a resource

FOCUS Versions

v1.0 v1.1 v1.2 v1.3 v1.4

Context

Using FOCUS data, an Engineer can deep dive on cost details for a single resource.

FOCUS SQL Query

SELECT ResourceId,
  ResourceName,
  ResourceType,
  ChargeDescription,
  SkuId,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ?  AND ChargePeriodEnd < ?
  AND ResourceId=?
GROUP BY ResourceId,
  ResourceName,
  ResourceType, 
  ChargeDescription,
  SkuId