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

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.

Read the reference →

Operators

The full set: ==, +, between, like, is null, and the rest.

See the operators →

Pipe

The | that chains functions together by passing the left side into the right.

How chaining works →

AQL types

The type system: scalars, tables, dimensions, fields, and measures.

Browse the types →

Functions

The function library, grouped by category from aggregators to window functions.

Browse by category →

Quick lookup

If you already know what you're looking for, these flat tables are the fastest way in.

Functions cheatsheet

Every function in one scannable table, with full docs a click away.

Open the cheatsheet →

Operators cheatsheet

Every operator with a syntax example for each.

Open the cheatsheet →

See also

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