Usage model
The usage model stores time-series measurements of how accounts consume dimensions defined on plans and subscriptions (for example seats consumed, API credits, storage). It powers utilization views such as license utilization percentages when those features are enabled.
Prerequisites
- Accounts model
- Plans and Subscriptions should define dimension keys so usage rows align with entitlements
Field reference
Model keys
| Property | Type | Description |
|---|---|---|
account_id | string | Account being measured. |
dimension | string | Name of the dimension being reported; must match a key from plan or subscription dimensions for consistent rollups. |
timestamp | timestamp | Time the measurement applies to (sample time, period end, etc.). |
Default properties
| Property | Type | Description |
|---|---|---|
value | json | Measured usage. Often a number; JSON type allows structured payloads if your pipeline requires it. Parse expectations follow your workspace configuration. |
Configure
- Add model → Usage.
- Provide a query that emits one row per account, dimension, and timestamp (or grain you use).
- Map columns exactly to
account_id,dimension,timestamp, andvalue. - Validate, save, refresh.
- Confirm utilization or usage-driven widgets on Accounts for test accounts.
Tips
- Keep
dimensionstrings stable across plan, subscription, and usage models. - If you aggregate usage in the warehouse, ensure
timestampreflects the period your charts expect (for example daily buckets).