AQL Functions Overview
AQL functions are the main building blocks of an AQL expression. They transform an input into an output based on specified arguments, and are typically combined using the pipe operator.
This page is the entry point for all AQL functions. Each category below links to its own reference page with the full list of functions, their signatures, and examples.
| Category | What it does |
|---|---|
| Table Functions | Transform a table expression into another table. select, group, filter, unique, top, bottom. |
| Metric Functions | Modify the context of a metric expression. Includes Condition, Relationship, LOD, Time-based, and Window functions. |
| Aggregation Functions | Collapse multiple rows into a single value. SQL-equivalents of SUM, COUNT, AVG, plus statistical aggregates like percentile_cont and stdev. |
| Logical Functions | Branch on conditions: case, and, or, not, in. |
| Text Functions | String manipulation: concat, find, replace, regex helpers, padding, case conversion. |
| Time Intelligence Functions | Date/time helpers: truncation (day, month, year), formatting, unix conversion. |
| AI Functions | LLM-powered helpers for classification, summarization, similarity. Databricks and Snowflake only. |
| Null/Zero Handling Functions | coalesce, nullif, safe_divide. |
| SQL Passthrough Functions | Escape hatch to call native database functions when AQL doesn't cover what you need. |
| Miscellaneous Functions | cast, is_at_level, and other one-offs. |
See also
- AQL Cheatsheet: Functions: flat alphabetical list to Ctrl-F
- Operators:
==,+,between,like, etc. - Pipe operator: how functions chain together