Skip to main content

Formulas

The following are the available values for the columns[].formula.name and columns[].formula.args fields in Schema.

For example,

NameDescriptionTypeArgs
AddIntSum up intintList of columns containing int.
For example, ["schema1.col1", "schema2.col2", ...]
AddFloatSum up floatfloatList of columns containing float.
For example, ["schema1.col1", "schema2.col2", ...]
AddStringConcatenate stringstringList of columns containing string.
For example, ["schema1.col1", "schema2.col2", ...]
AndApply && OperatorboolList of columns containing bool.
For example, ["schema1.col1", "schema2.col2", ...]
OrApply || OperatorboolList of columns containing bool.
For example, ["schema1.col1", "schema2.col2", ...]
XOrIntApply | OperatorintList of columns containing int.
For example, ["schema1.col1", "schema2.col2", ...]
CopyCopy value from given columnanyOne column.
For example, ["schema1.col1"]
CurrentTimeMsCurrent time in Unix millisecondsint64[]
ToUnixMilliConvert date like 2006-01-02 to Unix millisecondsint64One column.
For example, ["schema1.col1"]
AddRandomTimeMsCopy value from given column, and add a random number between minimum and maximum to itint64One column, a minimum integer in string, and a maximum integer in string.
For example, ["schema1.col1", "-100", "100"]
AddRandomNumberCopy value from given column, and add a random number between minimum and maximum to itintOne column, a minimum integer in string, and a maximum integer in string.
For example, ["schema1.col1", "-100", "100"]