> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Window functions

> Snowflake window functions supported in Snowflake compatibility mode.

<span className="feature-tag">Preview</span>

Snowflake [window functions](https://docs.snowflake.com/en/sql-reference/functions-window) in [Snowflake compatibility mode](/reference-sql/snowflake/overview).

| Function | Support | Notes |
| :- | :- | :- |
| `CUME_DIST` | Supported | |
| `DENSE_RANK` | Supported | |
| `FIRST_VALUE` | Supported | |
| `LAG` | Supported | |
| `LAST_VALUE` | Supported | |
| `LEAD` | Supported | |
| `NTH_VALUE` | Supported | |
| `NTILE` | Supported | |
| `PERCENT_RANK` | Supported | |
| `RANK` | Supported | |
| `ROW_NUMBER` | Supported | |
| `CONDITIONAL_CHANGE_EVENT`, `CONDITIONAL_TRUE_EVENT`, `RATIO_TO_REPORT` | Not supported | |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.