Analyze costs by availability zone for a subaccount

Context

It is good practice for Engineering to monitor cost and usage of services by availability zone for all regions to ensure:

• there isn’t any cost/usage occurring outside of the expected locations
• your costs are spread according to an expected ratio

 

FOCUS Columns

FOCUS SQL Query

SELECT
  ProviderName,
  RegionName,
  AvailabilityZone,
  BillingPeriodStart,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE SubAccountId = ?
  AND ChargePeriodStart >= ? AND ChargePeriodEnd < ?
GROUP BY
  ProviderName,
  RegionName,
  AvailabilityZone,
  BillingPeriodStart
 ORDER BY ProviderName,
  RegionName,
  AvailabilityZone,
  BillingPeriodStart