Bigquery Functions
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
SDF is now a part of dbt Labs. Get live CTA previews, inline errors, and mesh support natively in the dbt platform. Learn more · Migrate to Fusion
any_valuefunction any_value($1) returns $1
array_aggfunction array_agg($1) returns array<$1>
array_avgfunction array_avg $1(array<$1>) returns double
where $1 in (int, bigint, float, double)
array_concat_aggfunction array_concat_agg(array<$1>) returns array<$1>
avgfunction avg $1($1) returns $1
where $1 in (double, interval)
function avg(bigint) returns double
bit_andfunction bit_and(bigint) returns bigint
bit_orfunction bit_or(bigint) returns bigint
bit_xorfunction bit_xor(bigint) returns bigint
corrfunction corr(float64, float64) returns float64
countfunction count($1) returns bigint
countiffunction countif(bool) returns bigint
covar_popfunction covar_pop(float64, float64) returns float64
covar_sampfunction covar_samp(float64, float64) returns float64
logical_andfunction logical_and(bool) returns bool
logical_orfunction logical_or(bool) returns bool
maxfunction max($1) returns $1
max_byfunction max_by($1, $2) returns $1
minfunction min($1) returns $1
min_byfunction min_by($1, $2) returns $1
stddev_popfunction stddev_pop(float64) returns float64
stddev_sampfunction stddev_samp(float64) returns float64
string_aggfunction string_agg $1($1) returns $1
where $1 in (string, bytes)
function string_agg $1($1, $1) returns $1
where $1 in (string, bytes)
sumfunction sum($1) returns $1
var_popfunction var_pop(float64) returns float64
var_sampfunction var_samp(float64) returns float64