Understanding costs across providers, billing periods, and service categories (Analytics, Compute, Database, Storage, etc.) provides valuable insight into total costs.
This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
Column names from the source use case.
35 rows. Scroll inside the table to see more.
select provider_name as provider_name,
billing_currency as billing_currency,
billing_period_start as billing_period_start,
service_category as service_category,
sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
and billing_period_end < $2::timestamptz
group by provider_name, billing_currency, billing_period_start, service_category
order by total_billed_cost desc nulls last, provider_name, billing_period_start, service_category nulls last
limit 500SELECT ProviderName, BillingCurrency, BillingPeriodStart, ServiceCategory, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? and BillingPeriodEnd < ? GROUP BY ProviderName, BillingCurrency, BillingPeriodStart, ServiceCategory ORDER BY TotalBilledCost DESC