Analyze virtual-currency purchase patterns (e.g., upfront) and actively monitor burn down to prevent overage charges.
Column names from the source use case.
The sample contains no virtual-currency Purchase charges: its only Purchase rows are three AWS Compute Savings Plan fees priced in Hours, so the PricingUnit filter has no virtual-currency unit to select.
SELECT
ServiceProviderName,
PublisherName,
ChargeDescription,
PricingUnit,
BillingCurrency,
SUM(PricingQuantity) AS TotalPricingQuantity,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND ChargeCategory = 'Purchase'
AND PricingUnit = ?
GROUP BY
ServiceProviderName,
PublisherName,
ChargeDescription,
PricingUnit,
BillingCurrencyNo virtual-currency Purchase charges are present in the sample: the only Purchase rows have PricingUnit Hours and describe AWS Compute Savings Plans.
SELECT
ServiceProviderName,
ChargeDescription,
PricingUnit,
BillingCurrency,
SUM(PricingQuantity) AS TotalPricingQuantity,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND ChargeCategory = 'Purchase'
AND PricingUnit = ?
GROUP BY
ServiceProviderName,
ChargeDescription,
PricingUnit,
BillingCurrency