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”}

Functionality

DuneSQL

List of functions by topic

Aggregate

Array

Binary

Bitwise

Color

Comparison

Conditional

Conversion

Date and time

Geospatial

HyperLogLog

JSON

Lambda

Machine learning

Map

Math

Quantile digest

Regular expression

Session

Set Digest

String

System

T-Digest

Teradata

URL

UUID

Window

Functionality

DuneSQL

​Aggregate

​Array

​Binary

​Bitwise

​Color

​Comparison

​Conditional

​Conversion

​Date and time

​Geospatial

​HyperLogLog

​JSON

​Lambda

​Machine learning

​Map

​Math

​Quantile digest

​Regular expression

​Session

​Set Digest

​String

​System

​T-Digest

​Teradata

​URL

​UUID

​Window

Aggregate

Array

Binary

Bitwise

Color

Comparison

Conditional

Conversion

Date and time

Geospatial

HyperLogLog

JSON

Lambda

Machine learning

Map

Math

Quantile digest

Regular expression

Session

Set Digest

String

System

T-Digest

Teradata

URL

UUID

Window