Using FOCUS data, an Engineer can deep dive on cost details for a single resource.
Column names from the source use case.
5 rows. Scroll inside the table to see more.
select resource_id as resource_id,
resource_name as resource_name,
resource_type as resource_type,
charge_description as charge_description,
sku_id as sku_id,
sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
and charge_period_end < $2::timestamptz
and resource_id = $3::text
group by resource_id, resource_name, resource_type, charge_description, sku_id
order by total_effective_cost desc nulls last, charge_description nulls last, sku_id nulls last, resource_id, resource_name nulls last, resource_type nulls last
limit 500SELECT 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