Other Functions

Syntax	Description	Example	Normal Query	Pushdown Query	Defined as Computed Column	Suggested as Computed Column
UUID()	Returns an universally unique identifier (UUID) string. The value is returned as a canonical UUID 36-character string	UUID() = 46707d92-02f4-4817-8116-a4c3b23e6266	❌	✔️	❌	❌
MONOTONICALLY_INCREASING_ID()	Returns monotonically increasing 64-bit integers. The generated ID is guaranteed to be monotonically increasing and unique, but not consecutive.	MONOTONICALLY_INCREASING_ID() = 1111111	✔️	✔️	❌	❌
EXPLODE(array)	Returns new rows for each element in the given array column.	EXPLODE(array[1, 2, 3]) = 1 2 3	✔️	❌	❌	❌
SIZE(expr)	Expr must be of type array or map and return the number of elements contained in array or map.	SIZE(array[1, 2, 3]) = 3	✔️	✔️	❌	❌