Finance manages tracking of budgets and must update long-term budgets with the actual costs billed each month so the budget is not exceeded.
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.
3 rows. Scroll inside the table to see more.
select provider_name as provider_name, billing_period_start as billing_period_start, billing_period_end as billing_period_end, 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_period_start, billing_period_end order by billing_period_start asc, provider_name asc, billing_period_end asc limit 500
SELECT ProviderName, BillingPeriodStart, BillingPeriodEnd, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ? GROUP BY ProviderName, BillingPeriodStart, BillingPeriodEnd