SQL-Based Billable Metrics — Defines billable metrics as SQL over the event stream — count of distinct users, sum of compute-seconds, max concurrent sessions — instead of hard-coded aggregations. Mediated events are its input, and the rating engine prices whatever the query returns.
SQL-Based Billable Metrics lives in the Consume & Meter phase of Fulfill & Bill — the stage where you activate what was sold, meter what's used, bill it right. In the corpus tool index this phase maps to the Meteringcategory.
The critical requirements that test this capability in UsagePricing's Usage-based billing & metering rubric — scored tool profiles link from the list below.
Can finance define a new meter without re-instrumenting the product?
The bar: Metrics defined declaratively (SQL or expression language) over raw events; new metrics rate historical data.