createAggregate
createAggregateCreates a new billable metric by specifying its name, data schema, aggregation queries, and data source.
Instructions
Create a new Billable Metric. Requires a name, data schema, aggregation queries, visual query builder config, and a data source. Host enforces user confirmation via the approval gate; do NOT ask the user to re-confirm before calling.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Name of the billable metric (required). | |
| dataschema | Yes | Data schema of the aggregate (JSON string, required). | |
| aggregation_query | Yes | Aggregate query — SQL/Jinja template for computing the metric (required). | |
| cust_agg_query | Yes | Customer aggregate query — SQL/Jinja template for customer-level computation (required). | |
| visual_query_builder | Yes | Visual query builder configuration object (required). | |
| datasource | Yes | Data source UUID (required). | |
| __userContext | No | Internal user context for multi-tenant authentication and approval workflow |