Snowflake 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
approx_count_distinctfunction approx_count_distinct($1, ...) returns decimal(38, 0)
approx_percentilefunction approx_percentile(double, double) returns double
approx_percentile_accumulatefunction approx_percentile_accumulate(double) returns object
approx_percentile_combinefunction approx_percentile_combine(object) returns object
approx_percentile_estimatefunction approx_percentile_estimate(object, double) returns double
approx_top_kfunction approx_top_k($1) returns array
function approx_top_k($1, decimal(38, 0)) returns array
function approx_top_k($1, decimal(38, 0), decimal(38, 0)) returns array
approx_top_k_accumulatefunction approx_top_k_accumulate($1, decimal(38, 0)) returns object
approx_top_k_combinefunction approx_top_k_combine(object) returns object
function approx_top_k_combine(object, decimal(38, 0)) returns object
approx_top_k_estimatefunction approx_top_k_estimate(object) returns array
function approx_top_k_estimate(object, decimal(38, 0)) returns array
approximate_jaccard_indexfunction approximate_jaccard_index(variant) returns double
approximate_similarityfunction approximate_similarity(variant) returns double
array_aggfunction array_agg($1) returns array
array_union_aggfunction array_union_agg(array) returns array
array_unique_aggfunction array_unique_agg($1) returns array
avgfunction avg(decimal(38, 0)) returns decimal(38, 0)
function avg(double) returns double
function avg(string) returns string
bitand_aggfunction bitand_agg(decimal(38, 0)) returns decimal(38, 0)
function bitand_agg(string) returns string
bitmap_bit_positionfunction bitmap_bit_position(decimal(38, 0)) returns decimal(38, 0)
bitmap_bucket_numberfunction bitmap_bucket_number(decimal(38, 0)) returns decimal(38, 0)
bitmap_construct_aggfunction bitmap_construct_agg(decimal(38, 0)) returns binary
bitmap_countfunction bitmap_count(binary) returns decimal(38, 0)
bitmap_or_aggfunction bitmap_or_agg(binary) returns binary
bitor_aggfunction bitor_agg(decimal(38, 0)) returns decimal(38, 0)
function bitor_agg(string) returns string
bitxor_aggfunction bitxor_agg(decimal(38, 0)) returns decimal(38, 0)
function bitxor_agg(string) returns string
booland_aggfunction booland_agg(decimal(38, 0)) returns boolean
function booland_agg(boolean) returns boolean
boolor_aggfunction boolor_agg(decimal(38, 0)) returns boolean
function boolor_agg(boolean) returns boolean
boolxor_aggfunction boolxor_agg(decimal(38, 0)) returns boolean
function boolxor_agg(boolean) returns boolean
corrfunction corr(double, double) returns double
countfunction count(...) returns decimal(38, 0)
count_iffunction count_if(boolean) returns decimal(38, 0)
covar_popfunction covar_pop(double, double) returns double
covar_sampfunction covar_samp(double, double) returns double
groupingfunction grouping(...) returns int
grouping_idfunction grouping_id($1, ...) returns decimal(38, 0)
hash_aggfunction hash_agg(...) returns decimal(19, 0)
function hash_agg($1) returns decimal(38, 0)
function hash_agg($1, $2) returns decimal(38, 0)
function hash_agg($1, $2, $3) returns decimal(38, 0)
function hash_agg($1, $2, $3, $4) returns decimal(38, 0)
function hash_agg($1, $2, $3, $4, $5) returns decimal(38, 0)
hllfunction hll($1, ...) returns decimal(38, 0)
hll_accumulatefunction hll_accumulate($1, ...) returns binary
hll_combinefunction hll_combine(binary) returns binary
hll_estimatefunction hll_estimate(binary) returns decimal(38, 0)
hll_exportfunction hll_export(binary) returns object
hll_importfunction hll_import(object) returns binary
kurtosisfunction kurtosis(decimal(38, 0)) returns double
function kurtosis(double) returns double
listaggfunction listagg(varchar) returns varchar
function listagg(varchar, varchar) returns varchar
maxfunction max($1) returns $1
max_byfunction max_by($1, $2) returns $1
function max_by($1, $2, decimal(38, 0)) returns array
medianfunction median(decimal(p, s)) returns decimal(rp, rs)
function median(double) returns double
minfunction min($1) returns $1
min_byfunction min_by($1, $2) returns $1
function min_by($1, $2, decimal(38, 0)) returns array
minhashfunction minhash(decimal(38, 0), $1, ...) returns variant
minhash_combinefunction minhash_combine(variant) returns variant
modefunction mode($1) returns $1
object_aggfunction object_agg(varchar, variant) returns object
percentile_contfunction percentile_cont(decimal(p,s), $1) returns $1
percentile_discfunction percentile_disc(decimal(p,s), $1) returns $1
regr_avgxfunction regr_avgx(double, double) returns double
regr_avgyfunction regr_avgy(double, double) returns double
regr_countfunction regr_count(double, double) returns double
regr_interceptfunction regr_intercept(double, double) returns double
regr_r2function regr_r2(double, double) returns double
regr_slopefunction regr_slope(double, double) returns double
regr_sxxfunction regr_sxx(double, double) returns double
regr_sxyfunction regr_sxy(double, double) returns double
regr_syyfunction regr_syy(double, double) returns double
skewfunction skew(decimal(38, 0)) returns double
function skew(double) returns double
stddevfunction stddev(decimal(38, 0)) returns double
function stddev(double) returns double
stddev_popfunction stddev_pop(decimal(38, 0)) returns double
function stddev_pop(double) returns double
stddev_sampfunction stddev_samp(decimal(38, 0)) returns double
function stddev_samp(double) returns double
sumfunction sum(decimal(p, s)) returns decimal(rp, s)
function sum(double) returns double
var_popfunction var_pop(decimal(38, 0)) returns double
function var_pop(double) returns double
var_sampfunction var_samp(decimal(38, 0)) returns double
function var_samp(double) returns double
variancefunction variance(decimal(38, 0)) returns double
function variance(double) returns double
variance_popfunction variance_pop(decimal(38, 0)) returns double
function variance_pop(double) returns double
variance_sampfunction variance_samp(decimal(38, 0)) returns double
function variance_samp(double) returns double