Bigquery Functions
Aggregate Functions
any_value
Supported Signatures
function any_value($1) returns $1
array_agg
Supported Signatures
function array_agg($1) returns array<$1>
array_avg
Supported Signatures
function array_avg $1(array<$1>) returns double
where $1 in (int, bigint, float, double)
array_concat_agg
Supported Signatures
function array_concat_agg(array<$1>) returns array<$1>
avg
Supported Signatures
function avg $1($1) returns $1
where $1 in (double, interval)
function avg(bigint) returns double
bit_and
Supported Signatures
function bit_and(bigint) returns bigint
bit_or
Supported Signatures
function bit_or(bigint) returns bigint
bit_xor
Supported Signatures
function bit_xor(bigint) returns bigint
corr
Supported Signatures
function corr(float64, float64) returns float64
count
Supported Signatures
function count($1) returns bigint
countif
Supported Signatures
function countif(bool) returns bigint
covar_pop
Supported Signatures
function covar_pop(float64, float64) returns float64
covar_samp
Supported Signatures
function covar_samp(float64, float64) returns float64
logical_and
Supported Signatures
function logical_and(bool) returns bool
logical_or
Supported Signatures
function logical_or(bool) returns bool
max
Supported Signatures
function max($1) returns $1
max_by
Supported Signatures
function max_by($1, $2) returns $1
min
Supported Signatures
function min($1) returns $1
min_by
Supported Signatures
function min_by($1, $2) returns $1
stddev_pop
Supported Signatures
function stddev_pop(float64) returns float64
stddev_samp
Supported Signatures
function stddev_samp(float64) returns float64
string_agg
Supported Signatures
function string_agg $1($1) returns $1
where $1 in (string, bytes)
function string_agg $1($1, $1) returns $1
where $1 in (string, bytes)
sum
Supported Signatures
function sum($1) returns $1
var_pop
Supported Signatures
function var_pop(float64) returns float64
var_samp
Supported Signatures
function var_samp(float64) returns float64