Query Patterns
You rarely write queries by hand - you describe the shape and Azi (or any agent) proposes it. These are the shapes that come up most.
| Pattern | Ask it like | Gives you |
|---|---|---|
| Aggregation over time | "average signups per hour over the last day" | a value bucketed by time |
| Threshold | "every hour with more than 40 signups" | rows past a cutoff |
| Comparison | "signups by campaign this week" | a metric split by a dimension |
| Trend | "signups this week vs last week" | period-over-period change |
Each becomes a warm query - an API + MCP tool (see Warm Queries). Save the ones your team re-derives; they become shared sources of truth.
Next steps
- The language these compile to -> KQL Basics
- Describe the shape and let Azi write it -> Working with Azi