Other

Cast

Converts the type of a variable. Consider using the "retype" step for additional functionality. –> learn more

CASE WHEN @expression IS NULL THEN NULL ELSE COALESCE(SAFE_CAST(@expression AS @castType), ERROR(FORMAT('Could not cast @expression to @castType, encountered value: %t', @expression))) END

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any Redivis type	true	-
@castType	enum	any of: INT64, FLOAT64, STRING, TIME, DATETIME, DATE, BOOLEAN	true	(Choose a type)
@safe	boolean	any boolean	true	-

Coalesce

Takes the first non-null value of a set of values. –> learn more

COALESCE(@expression)

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variables or literals	any Redivis type	true	-

Constant

Create a constant value as a variable –> learn more

undefined

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@literal	variable or literal	any Redivis type	true	-

Hash

Returns an MD5 hash of all values as a base64 encoded string. Non-string values will be first coerced to strings. Note that order of inputs will affect the hash. –> learn more

TO_BASE64(MD5(CONCAT(@expression)))

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variables or literals	any Redivis type	true	-

Sample

Create a random, deterministic value in the range of [0, 1) based on a specific set of variable(s). –> learn more

(FARM_FINGERPRINT(CONCAT(@variable)) + POW(2, 63)) / POW(2, 64)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variables	any Redivis type	true	-

UUID

Generate a random universally unique identifier (UUID) –> learn more

GENERATE_UUID()

Return type

string

Parameters