FunctionsJSON

json_array_length

Returns the number of top-level elements in the input JSON array.

json_array_length(…) → UInt64

Kind · scalar

Returns the number of top-level elements in the input JSON array.

Part of the JSON family.

json_array_elements_text

Returns each top-level JSON array element converted to text and packed into a JSON string array.

json_build_array

Constructs a JSON array from the function arguments for each row, preserving argument order.