AQL Reference

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 AQL & Metrics in the Documentation section.

How this section is organized

AQL has a small grammar and a large function library. The sidebar reflects that:

• AQL Expressions: the three kinds of expression you can write: table, metric, and explore.
• Operators: ==, +, between, like, is null, and the rest.
• Pipe: the | that chains functions together.
• AQL Types: the type system: scalars, tables, dimensions, fields, measures.
• Functions: the function library, grouped by category.

Quick lookup

If you already know what you're looking for:

• Functions cheatsheet: every function in one scannable table.
• Operators cheatsheet: every operator with examples.

See also

• AQL & Metrics: conceptual guides and learning material
• AML Reference: the modeling DSL that AQL queries against