Run ES|QL query
es_esqlExecute ES|QL queries on Kibana logs to aggregate data quickly and return results as a columns/values table, with support for text matching via MATCH and QSTR.
Instructions
Run an ES|QL query and return a columns/values table. Usually the fastest way to aggregate, e.g. FROM logs-* | WHERE status >= 500 | STATS n = COUNT(*) BY host. For text matching use MATCH(field, "phrase") or QSTR("field: phrase") — a leading-wildcard LIKE/RLIKE cannot use the index and is rejected.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ES|QL query string | |
| filter | No | Optional Query DSL filter applied before the ES|QL pipeline |