Reconcile billing data from vendors, provider marketplaces, and cloud service providers to pinpoint true spend and eliminate duplicate charges.
This query uses the ProviderName, and PublisherName columns. ProviderName and PublisherName are deprecated in v1.3 and will be removed in v1.4.
Column names from the source use case.
9 rows. Scroll inside the table to see more.
select provider_name,
publisher_name,
invoice_issuer_name,
billing_account_id,
billing_period_start,
sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
and charge_period_end < $2::timestamptz
group by 1, 2, 3, 4, 5
order by total_billed_cost desc nulls last, provider_name, publisher_name, invoice_issuer_name, billing_account_id
limit 500SELECT
ProviderName,
PublisherName,
InvoiceIssuerName,
InvoiceId,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
GROUP BY
ProviderName,
PublisherName,
InvoiceIssuerName,
InvoiceId