Governed semantic query
query_semanticRun a governed query against the semantic layer: choose an entity, then
the metrics, dimensions and filters you want. Aliases are resolved to
physical columns by the registry, so this cannot reach anything the
semantic model does not expose. The result includes the generated SQL.
Bounded and self-describing.
UK only. Costs 50 credits (50p). You are charged if the query reaches the
warehouse and then times out or errors there; a rejected query is free,
and so is one that matches no rows. Filter area facts on the
`analytics_area_id` from area_resolve; they are monthly, so a year
("2025") or quarter is widened to its months.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"entity": "<entity>"
},
"name": "query_semantic"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| joins | No | ||
| limit | No | ||
| entity | Yes | ||
| period | No | ||
| select | No | ||
| filters | No | ||
| metrics | No | ||
| order_by | No | ||
| dimensions | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||