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

# Math functions

> BigQuery mathematical functions supported in BigQuery compatibility mode.

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

BigQuery [mathematical functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions) in [BigQuery compatibility mode](/compatibility-modes/bigquery/overview).

| Function                                                                                                                                                                                                                                                                                                                                                                                                                                 | Support       | Notes                                        |
| :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :------------ | :------------------------------------------- |
| [`ABS`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#abs)                                                                                                                                                                                                                                                                                                                                   | Supported     |                                              |
| [`SIGN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sign)                                                                                                                                                                                                                                                                                                                                 | Supported     |                                              |
| [`CEIL`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ceil), [`CEILING`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ceiling)                                                                                                                                                                                                                 | Supported     |                                              |
| [`FLOOR`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#floor)                                                                                                                                                                                                                                                                                                                               | Supported     |                                              |
| [`ROUND`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#round)                                                                                                                                                                                                                                                                                                                               | Supported     |                                              |
| [`TRUNC`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#trunc)                                                                                                                                                                                                                                                                                                                               | Supported     |                                              |
| [`MOD`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#mod)                                                                                                                                                                                                                                                                                                                                   | Supported     |                                              |
| [`DIV`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#div)                                                                                                                                                                                                                                                                                                                                   | Supported     | Integer division.                            |
| [`POW`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow), [`POWER`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power)                                                                                                                                                                                                                       | Supported     |                                              |
| [`SQRT`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sqrt), [`CBRT`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cbrt)                                                                                                                                                                                                                       | Supported     |                                              |
| [`EXP`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#exp), [`LN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ln), [`LOG`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log), [`LOG10`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log10)         | Supported     |                                              |
| [`GREATEST`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#greatest), [`LEAST`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#least)                                                                                                                                                                                                             | Supported     |                                              |
| [`RAND`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#rand)                                                                                                                                                                                                                                                                                                                                 | Supported     |                                              |
| [`SIN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sin), [`COS`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cos), [`TAN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#tan), [`COT`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cot)           | Supported     |                                              |
| [`ASIN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#asin), [`ACOS`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#acos), [`ATAN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#atan), [`ATAN2`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#atan2) | Supported     |                                              |
| [`CSC`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#csc), [`SEC`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sec)                                                                                                                                                                                                                           | Supported     | Reciprocals of sine and cosine.              |
| [`SAFE_DIVIDE`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide)                                                                                                                                                                                                                                                                                                                   | Supported     | Returns `NULL` when the divisor is 0.        |
| `ACOSH`, `ASINH`, `ATANH`, `COSH`, `SINH`, `TANH`, `COTH`, `CSCH`, `SECH`                                                                                                                                                                                                                                                                                                                                                                | Not supported | Hyperbolic and inverse-hyperbolic functions. |
| `SAFE_ADD`, `SAFE_MULTIPLY`, `SAFE_NEGATE`, `SAFE_SUBTRACT`                                                                                                                                                                                                                                                                                                                                                                              | Not supported |                                              |
| `IS_INF`, `IS_NAN`, `RANGE_BUCKET`, `COSINE_DISTANCE`, `EUCLIDEAN_DISTANCE`                                                                                                                                                                                                                                                                                                                                                              | Not supported |                                              |
