AQL Reference
Signatures, grammar, and per-function details for the Analytics Query Language.
This is the reference for AQL: the signatures, the grammar, the function-by-function details. Use it to look something up.
For concepts (what AQL is for, how metrics work, how to think about Level of Detail, time comparisons, the order of operations), head to the AQL overview.
How this section is organized
AQL has a small grammar and a large function library. These pages map to that split: a handful of grammar pages, then the function library grouped by category.
AQL expressions
The three kinds of expression you can write: table, metric, and explore.
Operators
The full set: ==, +, between, like, is null, and the rest.
Pipe
The | that chains functions together by passing the left side into the right.
AQL types
The type system: scalars, tables, dimensions, fields, and measures.
Functions
The function library, grouped by category from aggregators to window functions.
Quick lookup
If you already know what you're looking for, the flat tables on Functions and the operators cheatsheet are the fastest way in.
See also
- AQL overview: conceptual guides and learning material
- AML Reference: the modeling DSL that AQL queries against