Snowflake Functions
Data Generation Functions
normal
Returns a normal distribution Supported Signatures
function normal(double, double, decimal(38, 0)) returns double
random
returns a random number sequence Supported Signatures
function random() returns decimal(38, 0)
function random(decimal(38, 0)) returns decimal(38, 0)
randstr
Returns a random string of alphanumeric characters Supported Signatures
function randstr(decimal(38, 0), decimal(38, 0)) returns varchar
seq1
returns a sequence of 1-byte integers Supported Signatures
function seq1() returns decimal(38, 0)
function seq1(decimal(38, 0)) returns decimal(38, 0)
seq2
returns a sequence of 2-byte integers Supported Signatures
function seq2() returns decimal(38, 0)
function seq2(decimal(38, 0)) returns decimal(38, 0)
seq4
returns a sequence of 4-byte integers Supported Signatures
function seq4() returns decimal(38, 0)
function seq4(decimal(38, 0)) returns decimal(38, 0)
seq8
returns a sequence of 8-byte integers Supported Signatures
function seq8() returns decimal(38, 0)
function seq8(decimal(38, 0)) returns decimal(38, 0)
uniform
Returns a uniform random distribution Supported Signatures
function uniform(decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function uniform(double, double, decimal(38, 0)) returns double
zipf
Returns a Zipf distribution Supported Signatures
function zipf(double, decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)