Documentation Index
Fetch the complete documentation index at: https://docs.sdf.com/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
Documentation Index
Fetch the complete documentation index at: https://docs.sdf.com/llms.txt
Use this file to discover all available pages before exploring further.
absfunction abs $1($1) returns $1
where $1 in (bigint, float64)
acosfunction acos $1($1) returns double
where $1 in (double, bigint)
acoshfunction acosh $1($1) returns double
where $1 in (double, bigint)
asinfunction asin $1($1) returns double
where $1 in (double, bigint)
asinhfunction asinh $1($1) returns double
where $1 in (double, bigint)
atanfunction atan $1($1) returns double
where $1 in (double, bigint)
atan2function atan2 $1, $2($1, $2) returns double
where $1 in (bigint, double)
and $2 in (bigint, double)
atanhfunction atanh $1($1) returns double
where $1 in (bigint, double)
cbrtfunction cbrt $1($1) returns double
where $1 in (bigint, double)
ceilfunction ceil(bigint) returns double
function ceil $1($1) returns $1
where $1 in (double)
ceilingfunction ceiling(bigint) returns double
function ceiling $1($1) returns $1
where $1 in (double)
cosfunction cos $1($1) returns double
where $1 in (bigint, double)
coshfunction cosh $1($1) returns double
where $1 in (bigint, double)
cotfunction cot $1($1) returns double
where $1 in (bigint, double)
cothfunction coth $1($1) returns double
where $1 in (bigint, double)
cscfunction csc $1($1) returns double
where $1 in (bigint, double)
cschfunction csch $1($1) returns double
where $1 in (bigint, double)
divfunction div $1($1, $1) returns $1
where $1 in (bigint)
function div(bigint, decimal(p,s)) returns decimal(p,s)
function div(decimal(p,s), bigint) returns decimal(p,s)
function div(decimal(p,s), bigint) returns decimal(p,s)
function div(bigint, decimal(p,s)) returns decimal(p,s)
expfunction exp(bigint) returns double
function exp $1($1) returns $1
where $1 in (double)
floorfunction floor $1($1) returns $1
where $1 in (double)
function floor(bigint) returns double
greatestfunction greatest $1($1, ...) returns $1
where $1 in (bigint, double, timestamp, date, time)
ieee_dividefunction ieee_divide $1, $2($1, $2) returns double
where $1 in (bigint, double)
and $2 in (bigint, double)
is_inffunction is_inf $1($1) returns bool
where $1 in (bigint, double)
is_nanfunction is_nan $1($1) returns bool
where $1 in (bigint, double)
leastfunction least $1($1, ...) returns $1
where $1 in (bigint, double, timestamp, date, time)
lnfunction ln(bigint) returns double
function ln $1($1) returns double
where $1 in (double)
logfunction log(bigint) returns double
function log $1($1) returns double
where $1 in (double)
function log $1($1, $1) returns $1
where $1 in (double)
function log(bigint, bigint) returns double
function log(bigint, decimal(p,s)) returns decimal(p,s)
function log(decimal(p,s), bigint) returns decimal(p,s)
function log(decimal(p,s), bigint) returns decimal(p,s)
function log(bigint, decimal(p,s)) returns decimal(p,s)
function log(double, bigint) returns double
function log(bigint, double) returns double
function log(decimal(p,s), double) returns double
function log(double, decimal(p,s)) returns double
function log(double, decimal(p,s)) returns double
function log(decimal(p,s), double) returns double
log10function log10(bigint) returns double
function log10 $1($1) returns $1
where $1 in (double)
modfunction mod $1($1, $1) returns $1
where $1 in (bigint)
function mod(bigint, decimal(p,s)) returns decimal(p,s)
function mod(decimal(p,s), bigint) returns decimal(p,s)
function mod(decimal(p,s), bigint) returns decimal(p,s)
function mod(bigint, decimal(p,s)) returns decimal(p,s)
powfunction pow $1($1, $1) returns $1
where $1 in (double)
function pow(bigint, bigint) returns double
function pow(bigint, decimal(p,s)) returns decimal(p,s)
function pow(decimal(p,s), bigint) returns decimal(p,s)
function pow(decimal(p,s), bigint) returns decimal(p,s)
function pow(bigint, decimal(p,s)) returns decimal(p,s)
function pow(double, bigint) returns double
function pow(bigint, double) returns double
function pow(double, decimal(p,s)) returns double
function pow(decimal(p,s), double) returns double
function pow(double, decimal(p,s)) returns double
function pow(decimal(p,s), double) returns double
powerfunction power $1($1, $1) returns $1
where $1 in (double)
function power(bigint, bigint) returns double
function power(bigint, decimal(p,s)) returns decimal(p,s)
function power(decimal(p,s), bigint) returns decimal(p,s)
function power(decimal(p,s), bigint) returns decimal(p,s)
function power(bigint, decimal(p,s)) returns decimal(p,s)
function power(double, bigint) returns double
function power(bigint, double) returns double
function power(double, decimal(p,s)) returns double
function power(decimal(p,s), double) returns double
function power(double, decimal(p,s)) returns double
function power(decimal(p,s), double) returns double
randfunction rand() returns double
range_bucketfunction range_bucket($1, array<$1>) returns int64
roundfunction round(bigint) returns double
function round $1($1) returns $1
where $1 in (double)
function round(bigint, bigint) returns double
function round $1($1, bigint) returns $1
where $1 in (double)
function round(bigint, bigint, rounding_mode string) returns double
where rounding_mode in (round_half_even, round_half_away_from_zero)
function round $1($1, bigint, rounding_mode string) returns $1
where rounding_mode in (round_half_even, round_half_away_from_zero)
where $1 in (double)
safe_addfunction safe_add $1($1, $1) returns $1
where $1 in (bigint, double)
function safe_add(bigint, decimal(p,s)) returns decimal(p,s)
function safe_add(decimal(p,s), bigint) returns decimal(p,s)
function safe_add(decimal(p,s), bigint) returns decimal(p,s)
function safe_add(bigint, decimal(p,s)) returns decimal(p,s)
function safe_add(double, bigint) returns double
function safe_add(bigint, double) returns double
function safe_add(double, decimal(p,s)) returns double
function safe_add(decimal(p,s), double) returns double
function safe_add(double, decimal(p,s)) returns double
function safe_add(decimal(p,s), double) returns double
safe_dividefunction safe_divide $1($1, $1) returns double
where $1 in (bigint, double)
function safe_divide(bigint, decimal(p,s)) returns decimal(p,s)
function safe_divide(decimal(p,s), bigint) returns decimal(p,s)
function safe_divide(decimal(p,s), bigint) returns decimal(p,s)
function safe_divide(bigint, decimal(p,s)) returns decimal(p,s)
function safe_divide(double, bigint) returns double
function safe_divide(bigint, double) returns double
function safe_divide(double, decimal(p,s)) returns double
function safe_divide(decimal(p,s), double) returns double
function safe_divide(double, decimal(p,s)) returns double
function safe_divide(decimal(p,s), double) returns double
safe_multiplyfunction safe_multiply $1($1, $1) returns $1
where $1 in (bigint, double)
function safe_multiply(bigint, decimal(p,s)) returns decimal(p,s)
function safe_multiply(decimal(p,s), bigint) returns decimal(p,s)
function safe_multiply(decimal(p,s), bigint) returns decimal(p,s)
function safe_multiply(bigint, decimal(p,s)) returns decimal(p,s)
function safe_multiply(double, bigint) returns double
function safe_multiply(bigint, double) returns double
function safe_multiply(double, decimal(p,s)) returns double
function safe_multiply(decimal(p,s), double) returns double
function safe_multiply(double, decimal(p,s)) returns double
function safe_multiply(decimal(p,s), double) returns double
safe_negatefunction safe_negate $1($1) returns $1
where $1 in (bigint, double)
safe_subtractfunction safe_subtract $1($1, $1) returns $1
where $1 in (bigint, double)
function safe_subtract(bigint, decimal(p,s)) returns decimal(p,s)
function safe_subtract(decimal(p,s), bigint) returns decimal(p,s)
function safe_subtract(decimal(p,s), bigint) returns decimal(p,s)
function safe_subtract(bigint, decimal(p,s)) returns decimal(p,s)
function safe_subtract(double, bigint) returns double
function safe_subtract(bigint, double) returns double
function safe_subtract(double, decimal(p,s)) returns double
function safe_subtract(decimal(p,s), double) returns double
function safe_subtract(double, decimal(p,s)) returns double
function safe_subtract(decimal(p,s), double) returns double
secfunction sec $1($1) returns double
where $1 in (bigint, double)
sechfunction sech $1($1) returns double
where $1 in (bigint, double)
signfunction sign $1($1) returns $1
where $1 in (bigint, double)
sinfunction sin $1($1) returns double
where $1 in (bigint, double)
sinhfunction sinh $1($1) returns double
where $1 in (bigint, double)
sqrtfunction sqrt(bigint) returns double
function sqrt $1($1) returns $1
where $1 in (double)
tanfunction tan $1($1) returns double
where $1 in (bigint, double)
tanhfunction tanh $1($1) returns double
where $1 in (bigint, double)
truncfunction trunc(bigint) returns double
function trunc $1($1) returns $1
where $1 in (double)
function trunc(bigint, bigint) returns double
function trunc $1($1, bigint) returns $1
where $1 in (double)