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

# List of functions by topic

## Aggregate

For more details, see `aggregate`\{.interpreted-text role="doc"}

* `approx_distinct`\{.interpreted-text role="func"}
* `approx_most_frequent`\{.interpreted-text role="func"}
* `approx_percentile`\{.interpreted-text role="func"}
* `approx_set()`
* `arbitrary`\{.interpreted-text role="func"}
* `array_agg`\{.interpreted-text role="func"}
* `avg`\{.interpreted-text role="func"}
* `bitwise_and_agg`\{.interpreted-text role="func"}
* `bitwise_or_agg`\{.interpreted-text role="func"}
* `bool_and`\{.interpreted-text role="func"}
* `bool_or`\{.interpreted-text role="func"}
* `checksum`\{.interpreted-text role="func"}
* `corr`\{.interpreted-text role="func"}
* `count`\{.interpreted-text role="func"}
* `count_if`\{.interpreted-text role="func"}
* `covar_pop`\{.interpreted-text role="func"}
* `covar_samp`\{.interpreted-text role="func"}
* `every`\{.interpreted-text role="func"}
* `geometric_mean`\{.interpreted-text role="func"}
* `histogram`\{.interpreted-text role="func"}
* `kurtosis`\{.interpreted-text role="func"}
* `map_agg`\{.interpreted-text role="func"}
* `map_union`\{.interpreted-text role="func"}
* `max`\{.interpreted-text role="func"}
* `max_by`\{.interpreted-text role="func"}
* `merge()`
* `min`\{.interpreted-text role="func"}
* `min_by`\{.interpreted-text role="func"}
* `multimap_agg`\{.interpreted-text role="func"}
* `numeric_histogram`\{.interpreted-text role="func"}
* `qdigest_agg()`
* `regr_intercept`\{.interpreted-text role="func"}
* `regr_slope`\{.interpreted-text role="func"}
* `skewness`\{.interpreted-text role="func"}
* `sum`\{.interpreted-text role="func"}
* `stddev`\{.interpreted-text role="func"}
* `stddev_pop`\{.interpreted-text role="func"}
* `stddev_samp`\{.interpreted-text role="func"}
* `tdigest_agg()`
* `variance`\{.interpreted-text role="func"}
* `var_pop`\{.interpreted-text role="func"}
* `var_samp`\{.interpreted-text role="func"}

## Array

For more details, see `array`\{.interpreted-text role="doc"}

* `all_match`\{.interpreted-text role="func"}
* `any_match`\{.interpreted-text role="func"}
* `array_distinct`\{.interpreted-text role="func"}
* `array_except`\{.interpreted-text role="func"}
* `array_intersect`\{.interpreted-text role="func"}
* `array_join`\{.interpreted-text role="func"}
* `array_max`\{.interpreted-text role="func"}
* `array_min`\{.interpreted-text role="func"}
* `array_position`\{.interpreted-text role="func"}
* `array_remove`\{.interpreted-text role="func"}
* `array_sort`\{.interpreted-text role="func"}
* `array_union`\{.interpreted-text role="func"}
* `arrays_overlap`\{.interpreted-text role="func"}
* `cardinality`\{.interpreted-text role="func"}
* `combinations`\{.interpreted-text role="func"}
* `concat()`
* `contains`\{.interpreted-text role="func"}
* `element_at`\{.interpreted-text role="func"}
* `filter`\{.interpreted-text role="func"}
* `flatten`\{.interpreted-text role="func"}
* `ngrams`\{.interpreted-text role="func"}
* `none_match`\{.interpreted-text role="func"}
* `reduce`\{.interpreted-text role="func"}
* `repeat`\{.interpreted-text role="func"}
* `reverse()`
* `sequence`\{.interpreted-text role="func"}
* `shuffle`\{.interpreted-text role="func"}
* `slice`\{.interpreted-text role="func"}
* `transform`\{.interpreted-text role="func"}
* `trim_array`\{.interpreted-text role="func"}
* `zip`\{.interpreted-text role="func"}
* `zip_with`\{.interpreted-text role="func"}

## Binary

For more details, see `binary`\{.interpreted-text role="doc"}

* `concat()`
* `crc32`\{.interpreted-text role="func"}
* `from_base32`\{.interpreted-text role="func"}
* `from_base64`\{.interpreted-text role="func"}
* `from_base64url`\{.interpreted-text role="func"}
* `from_big_endian_32`\{.interpreted-text role="func"}
* `from_big_endian_64`\{.interpreted-text role="func"}
* `from_hex`\{.interpreted-text role="func"}
* `from_ieee754_32`\{.interpreted-text role="func"}
* `from_ieee754_64`\{.interpreted-text role="func"}
* `hmac_md5`\{.interpreted-text role="func"}
* `hmac_sha1`\{.interpreted-text role="func"}
* `hmac_sha256`\{.interpreted-text role="func"}
* `hmac_sha512`\{.interpreted-text role="func"}
* `length()`
* `lpad()`
* `md5`\{.interpreted-text role="func"}
* `murmur3`\{.interpreted-text role="func"}
* `reverse()`
* `rpad()`
* `sha1`\{.interpreted-text role="func"}
* `sha256`\{.interpreted-text role="func"}
* `sha512`\{.interpreted-text role="func"}
* `spooky_hash_v2_32`\{.interpreted-text role="func"}
* `spooky_hash_v2_64`\{.interpreted-text role="func"}
* `substr()`
* `to_base32`\{.interpreted-text role="func"}
* `to_base64`\{.interpreted-text role="func"}
* `to_base64url`\{.interpreted-text role="func"}
* `to_big_endian_32`\{.interpreted-text role="func"}
* `to_big_endian_64`\{.interpreted-text role="func"}
* `to_hex`\{.interpreted-text role="func"}
* `to_ieee754_32`\{.interpreted-text role="func"}
* `to_ieee754_64`\{.interpreted-text role="func"}
* `xxhash64`\{.interpreted-text role="func"}

## Bitwise

For more details, see `bitwise`\{.interpreted-text role="doc"}

* `bit_count`\{.interpreted-text role="func"}
* `bitwise_and`\{.interpreted-text role="func"}
* `bitwise_left_shift`\{.interpreted-text role="func"}
* `bitwise_not`\{.interpreted-text role="func"}
* `bitwise_or`\{.interpreted-text role="func"}
* `bitwise_right_shift`\{.interpreted-text role="func"}
* `bitwise_right_shift_arithmetic`\{.interpreted-text role="func"}
* `bitwise_xor`\{.interpreted-text role="func"}

## Color

For more details, see `color`\{.interpreted-text role="doc"}

* `bar`\{.interpreted-text role="func"}
* `color`\{.interpreted-text role="func"}
* `render`\{.interpreted-text role="func"}
* `rgb`\{.interpreted-text role="func"}

# Comparison

For more details, see `comparison`\{.interpreted-text role="doc"}

* `greatest`\{.interpreted-text role="func"}
* `least`\{.interpreted-text role="func"}

# Conditional

For more details, see `conditional`\{.interpreted-text role="doc"}

* `coalesce <coalesce_function>`\{.interpreted-text role="ref"}
* `if <if_function>`\{.interpreted-text role="ref"}
* `nullif <nullif_function>`\{.interpreted-text role="ref"}
* `try <try_function>`\{.interpreted-text role="ref"}

# Conversion

For more details, see `conversion`\{.interpreted-text role="doc"}

* `cast`\{.interpreted-text role="func"}
* `format`\{.interpreted-text role="func"}
* `try_cast`\{.interpreted-text role="func"}
* `typeof`\{.interpreted-text role="func"}

# Date and time

For more details, see `datetime`\{.interpreted-text role="doc"}

* `AT TIME ZONE <at_time_zone_operator>`\{.interpreted-text role="ref"}
* `current_date`\{.interpreted-text role="data"}
* `current_time`\{.interpreted-text role="data"}
* `current_timestamp`\{.interpreted-text role="data"}
* `localtime`\{.interpreted-text role="data"}
* `localtimestamp`\{.interpreted-text role="data"}
* `current_timezone`\{.interpreted-text role="func"}
* `date`\{.interpreted-text role="func"}
* `date_add`\{.interpreted-text role="func"}
* `date_diff`\{.interpreted-text role="func"}
* `date_format`\{.interpreted-text role="func"}
* `date_parse`\{.interpreted-text role="func"}
* `date_trunc`\{.interpreted-text role="func"}
* `format_datetime`\{.interpreted-text role="func"}
* `from_iso8601_date`\{.interpreted-text role="func"}
* `from_iso8601_timestamp`\{.interpreted-text role="func"}
* `from_unixtime`\{.interpreted-text role="func"}
* `from_unixtime_nanos`\{.interpreted-text role="func"}
* `human_readable_seconds`\{.interpreted-text role="func"}
* `last_day_of_month`\{.interpreted-text role="func"}
* `now`\{.interpreted-text role="func"}
* `parse_duration`\{.interpreted-text role="func"}
* `to_iso8601`\{.interpreted-text role="func"}
* `to_milliseconds`\{.interpreted-text role="func"}
* `to_unixtime`\{.interpreted-text role="func"}
* `with_timezone`\{.interpreted-text role="func"}

# Geospatial

For more details, see `geospatial`\{.interpreted-text role="doc"}

* `bing_tile`\{.interpreted-text role="func"}
* `bing_tile_at`\{.interpreted-text role="func"}
* `bing_tile_coordinates`\{.interpreted-text role="func"}
* `bing_tile_polygon`\{.interpreted-text role="func"}
* `bing_tile_quadkey`\{.interpreted-text role="func"}
* `bing_tile_zoom_level`\{.interpreted-text role="func"}
* `bing_tiles_around`\{.interpreted-text role="func"}
* `convex_hull_agg`\{.interpreted-text role="func"}
* `from_encoded_polyline`\{.interpreted-text role="func"}
* `from_geojson_geometry`\{.interpreted-text role="func"}
* `geometry_from_hadoop_shape`\{.interpreted-text role="func"}
* `geometry_invalid_reason`\{.interpreted-text role="func"}
* `geometry_nearest_points`\{.interpreted-text role="func"}
* `geometry_to_bing_tiles`\{.interpreted-text role="func"}
* `geometry_union`\{.interpreted-text role="func"}
* `geometry_union_agg`\{.interpreted-text role="func"}
* `great_circle_distance`\{.interpreted-text role="func"}
* `line_interpolate_point`\{.interpreted-text role="func"}
* `line_locate_point`\{.interpreted-text role="func"}
* `simplify_geometry`\{.interpreted-text role="func"}
* `ST_Area`\{.interpreted-text role="func"}
* `ST_AsBinary`\{.interpreted-text role="func"}
* `ST_AsText`\{.interpreted-text role="func"}
* `ST_Boundary`\{.interpreted-text role="func"}
* `ST_Buffer`\{.interpreted-text role="func"}
* `ST_Centroid`\{.interpreted-text role="func"}
* `ST_Contains`\{.interpreted-text role="func"}
* `ST_ConvexHull`\{.interpreted-text role="func"}
* `ST_CoordDim`\{.interpreted-text role="func"}
* `ST_Crosses`\{.interpreted-text role="func"}
* `ST_Difference`\{.interpreted-text role="func"}
* `ST_Dimension`\{.interpreted-text role="func"}
* `ST_Disjoint`\{.interpreted-text role="func"}
* `ST_Distance`\{.interpreted-text role="func"}
* `ST_EndPoint`\{.interpreted-text role="func"}
* `ST_Envelope`\{.interpreted-text role="func"}
* `ST_Equals`\{.interpreted-text role="func"}
* `ST_ExteriorRing`\{.interpreted-text role="func"}
* `ST_Geometries`\{.interpreted-text role="func"}
* `ST_GeometryFromText`\{.interpreted-text role="func"}
* `ST_GeometryN`\{.interpreted-text role="func"}
* `ST_GeometryType`\{.interpreted-text role="func"}
* `ST_GeomFromBinary`\{.interpreted-text role="func"}
* `ST_InteriorRings`\{.interpreted-text role="func"}
* `ST_InteriorRingN`\{.interpreted-text role="func"}
* `ST_Intersects`\{.interpreted-text role="func"}
* `ST_Intersection`\{.interpreted-text role="func"}
* `ST_IsClosed`\{.interpreted-text role="func"}
* `ST_IsEmpty`\{.interpreted-text role="func"}
* `ST_IsSimple`\{.interpreted-text role="func"}
* `ST_IsRing`\{.interpreted-text role="func"}
* `ST_IsValid`\{.interpreted-text role="func"}
* `ST_Length`\{.interpreted-text role="func"}
* `ST_LineFromText`\{.interpreted-text role="func"}
* `ST_LineString`\{.interpreted-text role="func"}
* `ST_MultiPoint`\{.interpreted-text role="func"}
* `ST_NumGeometries`\{.interpreted-text role="func"}
* `ST_NumInteriorRing`\{.interpreted-text role="func"}
* `ST_NumPoints`\{.interpreted-text role="func"}
* `ST_Overlaps`\{.interpreted-text role="func"}
* `ST_Point`\{.interpreted-text role="func"}
* `ST_PointN`\{.interpreted-text role="func"}
* `ST_Points`\{.interpreted-text role="func"}
* `ST_Polygon`\{.interpreted-text role="func"}
* `ST_Relate`\{.interpreted-text role="func"}
* `ST_StartPoint`\{.interpreted-text role="func"}
* `ST_SymDifference`\{.interpreted-text role="func"}
* `ST_Touches`\{.interpreted-text role="func"}
* `ST_Union`\{.interpreted-text role="func"}
* `ST_Within`\{.interpreted-text role="func"}
* `ST_X`\{.interpreted-text role="func"}
* `ST_XMax`\{.interpreted-text role="func"}
* `ST_XMin`\{.interpreted-text role="func"}
* `ST_Y`\{.interpreted-text role="func"}
* `ST_YMax`\{.interpreted-text role="func"}
* `ST_YMin`\{.interpreted-text role="func"}
* `to_encoded_polyline`\{.interpreted-text role="func"}
* `to_geojson_geometry`\{.interpreted-text role="func"}
* `to_geometry`\{.interpreted-text role="func"}
* `to_spherical_geography`\{.interpreted-text role="func"}

# HyperLogLog

For more details, see `hyperloglog`\{.interpreted-text role="doc"}

* `approx_set`\{.interpreted-text role="func"}
* `cardinality()`
* `empty_approx_set`\{.interpreted-text role="func"}
* `merge`\{.interpreted-text role="func"}

# JSON

For more details, see `json`\{.interpreted-text role="doc"}

* `is_json_scalar`\{.interpreted-text role="func"}
* `json_array() <json_array>`\{.interpreted-text role="ref"}
* `json_array_contains`\{.interpreted-text role="func"}
* `json_array_get`\{.interpreted-text role="func"}
* `json_array_length`\{.interpreted-text role="func"}
* `json_exists() <json_exists>`\{.interpreted-text role="ref"}
* `json_extract`\{.interpreted-text role="func"}
* `json_extract_scalar`\{.interpreted-text role="func"}
* `json_format`\{.interpreted-text role="func"}
* `json_parse`\{.interpreted-text role="func"}
* `json_object() <json_object>`\{.interpreted-text role="ref"}
* `json_query() <json_query>`\{.interpreted-text role="ref"}
* `json_size`\{.interpreted-text role="func"}
* `json_value() <json_value>`\{.interpreted-text role="ref"}

# Lambda

For more details, see `lambda`\{.interpreted-text role="doc"}

* `any_match`\{.interpreted-text role="func"}
* `reduce_agg`\{.interpreted-text role="func"}
* `regexp_replace`\{.interpreted-text role="func"}
* `transform`\{.interpreted-text role="func"}

# Machine learning

For more details, see `ml`\{.interpreted-text role="doc"}

* `classify`\{.interpreted-text role="func"}
* `features`\{.interpreted-text role="func"}
* `learn_classifier`\{.interpreted-text role="func"}
* `learn_libsvm_classifier`\{.interpreted-text role="func"}
* `learn_libsvm_regressor`\{.interpreted-text role="func"}
* `learn_regressor`\{.interpreted-text role="func"}
* `regress`\{.interpreted-text role="func"}

# Map

For more details, see `map`\{.interpreted-text role="doc"}

* `cardinality`\{.interpreted-text role="func"}
* `element_at`\{.interpreted-text role="func"}
* `map`\{.interpreted-text role="func"}
* `map_concat`\{.interpreted-text role="func"}
* `map_entries`\{.interpreted-text role="func"}
* `map_filter`\{.interpreted-text role="func"}
* `map_from_entries`\{.interpreted-text role="func"}
* `map_keys`\{.interpreted-text role="func"}
* `map_values`\{.interpreted-text role="func"}
* `map_zip_with`\{.interpreted-text role="func"}
* `multimap_from_entries`\{.interpreted-text role="func"}
* `transform_keys`\{.interpreted-text role="func"}
* `transform_values`\{.interpreted-text role="func"}

# Math

For more details, see `math`\{.interpreted-text role="doc"}

* `abs`\{.interpreted-text role="func"}
* `acos`\{.interpreted-text role="func"}
* `asin`\{.interpreted-text role="func"}
* `atan`\{.interpreted-text role="func"}
* `beta_cdf`\{.interpreted-text role="func"}
* `cbrt`\{.interpreted-text role="func"}
* `ceil`\{.interpreted-text role="func"}
* `cos`\{.interpreted-text role="func"}
* `cosh`\{.interpreted-text role="func"}
* `cosine_similarity`\{.interpreted-text role="func"}
* `degrees`\{.interpreted-text role="func"}
* `e`\{.interpreted-text role="func"}
* `exp`\{.interpreted-text role="func"}
* `floor`\{.interpreted-text role="func"}
* `from_base`\{.interpreted-text role="func"}
* `infinity`\{.interpreted-text role="func"}
* `inverse_beta_cdf`\{.interpreted-text role="func"}
* `inverse_normal_cdf`\{.interpreted-text role="func"}
* `is_finite`\{.interpreted-text role="func"}
* `is_nan`\{.interpreted-text role="func"}
* `ln`\{.interpreted-text role="func"}
* `log`\{.interpreted-text role="func"}
* `log2`\{.interpreted-text role="func"}
* `log10`\{.interpreted-text role="func"}
* `mod`\{.interpreted-text role="func"}
* `nan`\{.interpreted-text role="func"}
* `normal_cdf`\{.interpreted-text role="func"}
* `pi`\{.interpreted-text role="func"}
* `pow`\{.interpreted-text role="func"}
* `power`\{.interpreted-text role="func"}
* `radians`\{.interpreted-text role="func"}
* `rand`\{.interpreted-text role="func"}
* `random`\{.interpreted-text role="func"}
* `round`\{.interpreted-text role="func"}
* `sign`\{.interpreted-text role="func"}
* `sin`\{.interpreted-text role="func"}
* `sqrt`\{.interpreted-text role="func"}
* `tan`\{.interpreted-text role="func"}
* `tanh`\{.interpreted-text role="func"}
* `to_base`\{.interpreted-text role="func"}
* `truncate`\{.interpreted-text role="func"}
* `width_bucket`\{.interpreted-text role="func"}
* `wilson_interval_lower`\{.interpreted-text role="func"}
* `wilson_interval_upper`\{.interpreted-text role="func"}

# Quantile digest

For more details, see `qdigest`\{.interpreted-text role="doc"}

* `merge()`
* `qdigest_agg`\{.interpreted-text role="func"}
* `value_at_quantile`\{.interpreted-text role="func"}
* `values_at_quantiles`\{.interpreted-text role="func"}

# Regular expression

For more details, see `regexp`\{.interpreted-text role="doc"}

* `regexp_count`\{.interpreted-text role="func"}
* `regexp_extract`\{.interpreted-text role="func"}
* `regexp_extract_all`\{.interpreted-text role="func"}
* `regexp_like`\{.interpreted-text role="func"}
* `regexp_position`\{.interpreted-text role="func"}
* `regexp_replace`\{.interpreted-text role="func"}
* `regexp_split`\{.interpreted-text role="func"}

# Session

For more details, see `session`\{.interpreted-text role="doc"}

* `current_catalog`\{.interpreted-text role="data"}
* `current_groups`\{.interpreted-text role="func"}
* `current_schema`\{.interpreted-text role="data"}
* `current_user`\{.interpreted-text role="data"}

# Set Digest

For more details, see `setdigest`\{.interpreted-text role="doc"}

* `make_set_digest`\{.interpreted-text role="func"}
* `merge_set_digest`\{.interpreted-text role="func"}
* `cardinality() <setdigest-cardinality>`\{.interpreted-textrole="ref"}
* `intersection_cardinality`\{.interpreted-text role="func"}
* `jaccard_index`\{.interpreted-text role="func"}
* `hash_counts`\{.interpreted-text role="func"}

# String

For more details, see `string`\{.interpreted-text role="doc"}

* `chr`\{.interpreted-text role="func"}
* `codepoint`\{.interpreted-text role="func"}
* `concat`\{.interpreted-text role="func"}
* `concat_ws`\{.interpreted-text role="func"}
* `format`\{.interpreted-text role="func"}
* `from_utf8`\{.interpreted-text role="func"}
* `hamming_distance`\{.interpreted-text role="func"}
* `length`\{.interpreted-text role="func"}
* `levenshtein_distance`\{.interpreted-text role="func"}
* `lower`\{.interpreted-text role="func"}
* `lpad`\{.interpreted-text role="func"}
* `ltrim`\{.interpreted-text role="func"}
* `luhn_check`\{.interpreted-text role="func"}
* `normalize`\{.interpreted-text role="func"}
* `position`\{.interpreted-text role="func"}
* `replace`\{.interpreted-text role="func"}
* `reverse`\{.interpreted-text role="func"}
* `rpad`\{.interpreted-text role="func"}
* `rtrim`\{.interpreted-text role="func"}
* `soundex`\{.interpreted-text role="func"}
* `split`\{.interpreted-text role="func"}
* `split_part`\{.interpreted-text role="func"}
* `split_to_map`\{.interpreted-text role="func"}
* `split_to_multimap`\{.interpreted-text role="func"}
* `starts_with`\{.interpreted-text role="func"}
* `strpos`\{.interpreted-text role="func"}
* `substr`\{.interpreted-text role="func"}
* `substring`\{.interpreted-text role="func"}
* `to_utf8`\{.interpreted-text role="func"}
* `translate`\{.interpreted-text role="func"}
* `trim`\{.interpreted-text role="func"}
* `upper`\{.interpreted-text role="func"}
* `word_stem`\{.interpreted-text role="func"}

# System

For more details, see `system`\{.interpreted-text role="doc"}

* `version`\{.interpreted-text role="func"}

# T-Digest

For more details, see `tdigest`\{.interpreted-text role="doc"}

* `merge()`
* `tdigest_agg`\{.interpreted-text role="func"}
* `value_at_quantile()`

# Teradata

For more details, see `teradata`\{.interpreted-text role="doc"}

* `char2hexint`\{.interpreted-text role="func"}
* `index`\{.interpreted-text role="func"}
* `to_char`\{.interpreted-text role="func"}
* `to_timestamp`\{.interpreted-text role="func"}
* `to_date`\{.interpreted-text role="func"}

# URL

For more details, see `url`\{.interpreted-text role="doc"}

* `url_decode`\{.interpreted-text role="func"}
* `url_encode`\{.interpreted-text role="func"}
* `url_extract_fragment`\{.interpreted-text role="func"}
* `url_extract_host`\{.interpreted-text role="func"}
* `url_extract_parameter`\{.interpreted-text role="func"}
* `url_extract_path`\{.interpreted-text role="func"}
* `url_extract_port`\{.interpreted-text role="func"}
* `url_extract_protocol`\{.interpreted-text role="func"}
* `url_extract_query`\{.interpreted-text role="func"}

# UUID

For more details, see `uuid`\{.interpreted-text role="doc"}

* `uuid`\{.interpreted-text role="func"}

# Window

For more details, see `window`\{.interpreted-text role="doc"}

* `cume_dist`\{.interpreted-text role="func"}
* `dense_rank`\{.interpreted-text role="func"}
* `f_value`\{.interpreted-text role="func"}
* `lag`\{.interpreted-text role="func"}
* `last_value`\{.interpreted-text role="func"}
* `lead`\{.interpreted-text role="func"}
* `nth_value`\{.interpreted-text role="func"}
* `ntile`\{.interpreted-text role="func"}
* `percent_rank`\{.interpreted-text role="func"}
* `rank`\{.interpreted-text role="func"}
* `row_number`\{.interpreted-text role="func"}