Index

A

abs() (built-in function) acos() (built-in function) approx_distinct() (built-in function), [1] approx_percentile() (built-in function), [1], [2], [3], [4] arbitrary() (built-in function) array_agg() (built-in function) array_distinct() (built-in function) array_intersect() (built-in function) array_join() (built-in function)

array_max() (built-in function) array_min() (built-in function) array_position() (built-in function) array_remove() (built-in function) array_sort() (built-in function) array_union() (built-in function) asin() (built-in function) atan() (built-in function) atan2() (built-in function) avg() (built-in function)

B

bar() (built-in function), [1] bit_count() (built-in function) bitwise_and() (built-in function) bitwise_and_agg() (built-in function) bitwise_not() (built-in function)

bitwise_or() (built-in function) bitwise_or_agg() (built-in function) bitwise_xor() (built-in function) bool_and() (built-in function) bool_or() (built-in function)

C

cardinality() (built-in function) cast() (built-in function) cbrt() (built-in function) ceil() (built-in function) ceiling() (built-in function) char2hexint() (built-in function) checksum() (built-in function) chr() (built-in function) coalesce() (built-in function) color() (built-in function), [1], [2] concat() (built-in function)

contains() (built-in function) corr() (built-in function) cos() (built-in function) cosh() (built-in function) cosine_similarity() (built-in function) count() (built-in function), [1] count_if() (built-in function) covar_pop() (built-in function) covar_samp() (built-in function) cume_dist() (built-in function) current_timezone() (built-in function)

D

date_add() (built-in function) date_diff() (built-in function) date_format() (built-in function) date_parse() (built-in function) date_trunc() (built-in function) day() (built-in function)

day_of_month() (built-in function) day_of_week() (built-in function) day_of_year() (built-in function) degrees() (built-in function) dense_rank() (built-in function) dow() (built-in function) doy() (built-in function)

E

e() (built-in function) element_at() (built-in function)

every() (built-in function) exp() (built-in function) extract() (built-in function)

F

first_value() (built-in function) flatten() (built-in function) floor() (built-in function) format_datetime() (built-in function) from_base() (built-in function) from_base64() (built-in function)

from_base64url() (built-in function) from_hex() (built-in function) from_iso8601_date() (built-in function) from_iso8601_timestamp() (built-in function) from_unixtime() (built-in function), [1], [2] from_utf8() (built-in function), [1]

G

geometric_mean() (built-in function)

greatest() (built-in function) grouping() (built-in function)

H

histogram() (built-in function)

hour() (built-in function)

I

if() (built-in function), [1] index() (built-in function) infinity() (built-in function)

is_finite() (built-in function) is_infinite() (built-in function) is_nan() (built-in function)

J

json_array_contains() (built-in function) json_array_get() (built-in function) json_array_length() (built-in function) json_extract() (built-in function)

json_extract_scalar() (built-in function) json_format() (built-in function) json_parse() (built-in function) json_size() (built-in function)

L

lag() (built-in function) last_value() (built-in function) lead() (built-in function) least() (built-in function) length() (built-in function) ln() (built-in function)

log() (built-in function) log10() (built-in function) log2() (built-in function) lower() (built-in function) lpad() (built-in function) ltrim() (built-in function)

M

map() (built-in function) map_agg() (built-in function) map_concat() (built-in function) map_keys() (built-in function) map_union() (built-in function) map_values() (built-in function) max() (built-in function), [1]

max_by() (built-in function), [1] md5() (built-in function) min() (built-in function), [1] min_by() (built-in function), [1] minute() (built-in function) mod() (built-in function) month() (built-in function) multimap_agg() (built-in function)

N

nan() (built-in function) normalize() (built-in function), [1] now() (built-in function)

nth_value() (built-in function) ntile() (built-in function) nullif() (built-in function) numeric_histogram() (built-in function), [1]

P

parse_datetime() (built-in function) percent_rank() (built-in function) pi() (built-in function)

position() (built-in function) pow() (built-in function) power() (built-in function)

Q

quarter() (built-in function)

R

radians() (built-in function) rand() (built-in function) random() (built-in function), [1] rank() (built-in function) regexp_extract() (built-in function), [1] regexp_extract_all() (built-in function), [1] regexp_like() (built-in function) regexp_replace() (built-in function), [1] regexp_split() (built-in function) regr_intercept() (built-in function) regr_slope() (built-in function) render() (built-in function), [1]

replace() (built-in function), [1] reverse() (built-in function) RFC RFC 1866#section-8.2.1 RFC 2396 RFC 2822 RFC 4627 rgb() (built-in function) round() (built-in function), [1] row_number() (built-in function) rpad() (built-in function) rtrim() (built-in function) runtime.kill_query() (built-in function)

S

second() (built-in function) sequence() (built-in function), [1], [2] sha1() (built-in function) sha256() (built-in function) sha512() (built-in function) shuffle() (built-in function) sign() (built-in function) sin() (built-in function) slice() (built-in function) split() (built-in function), [1]

split_part() (built-in function) split_to_map() (built-in function) sqrt() (built-in function) stddev() (built-in function) stddev_pop() (built-in function) stddev_samp() (built-in function) strpos() (built-in function) substr() (built-in function), [1] substring() (built-in function), [1] sum() (built-in function)

T

tan() (built-in function) tanh() (built-in function) timezone_hour() (built-in function) timezone_minute() (built-in function) to_base() (built-in function) to_base64() (built-in function) to_base64url() (built-in function) to_char() (built-in function) to_date() (built-in function)

to_hex() (built-in function) to_iso8601() (built-in function) to_timestamp() (built-in function) to_unixtime() (built-in function) to_utf8() (built-in function) trim() (built-in function) truncate() (built-in function) try() (built-in function) try_cast() (built-in function) typeof() (built-in function)

U

upper() (built-in function) url_decode() (built-in function) url_encode() (built-in function) url_extract_fragment() (built-in function) url_extract_host() (built-in function)

url_extract_parameter() (built-in function) url_extract_path() (built-in function) url_extract_port() (built-in function) url_extract_protocol() (built-in function) url_extract_query() (built-in function)

V

var_pop() (built-in function)

var_samp() (built-in function) variance() (built-in function)

W

week() (built-in function)

week_of_year() (built-in function) width_bucket() (built-in function), [1]

Y

year() (built-in function)

year_of_week() (built-in function) yow() (built-in function)

Z

zip() (built-in function)