> ## 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 |       |