Miscellaneous Functions¶

In this Topic:

List of Functions¶

Sub-category	Function	Notes
System	SYSTEM$ABORT_SESSION
	SYSTEM$ABORT_TRANSACTION
	SYSTEM$CANCEL_ALL_QUERIES
	SYSTEM$CANCEL_QUERY
	SYSTEM$CLUSTERING_DEPTH
	SYSTEM$CLUSTERING_INFORMATION
	SYSTEM$CLUSTERING_RATIO
	SYSTEM$LAST_CHANGE_COMMIT_TIME
	SYSTEM$PIPE_FORCE_RESUME
	SYSTEM$PIPE_STATUS
	SYSTEM$TYPEOF
	SYSTEM$WAIT
Utility	GET_DDL
	HASH
	HASH_AGG
Data Generation	RANDOM
	SEQ1 / SEQ2 / SEQ4 / SEQ8
	UUID_STRING
Random Distribution	NORMAL
	RANDSTR
	UNIFORM
	ZIPF

Sequences generated by data generation functions are not guaranteed to be ordered and gap-free. This is because the numbers may be generated in parallel, in an unsynchronized fashion.

For more details about sequences in Snowflake, see Using Sequences.

Random distribution functions are deterministic.
Each random distribution function takes a generator expression, gen, as its last argument. The generator expression, gen, can be constant or variable:
- If constant, then the result of the random distribution function is constant (unless there are other, variable arguments, which is currently only supported for the RANDSTR function).
- If variable, then the result of the random distribution function is variable.
Generator expressions must be a type 64-bit integer, although implicit conversions are allowed. Any expression that can be converted into a 64-bit integer can be used as a generator expression.
The randomness of any random distribution function is directly linked to the randomness of its generator expression. For most practical purposes, the RANDOM data generation function is the best choice for randomly-generated integer values.