JSON_LENGTH
Returns the number of elements in a JSON object or array.
Analyze Syntax
func.json_length(get_column(table, 'data'))
Analyze Examples
func.json_length(get_column(table, 'data'))
┌───┐
│ 2 │
└───┘
SQL Syntax
JSON_LENGTH(<data>)
SQL Examples
SELECT JSON_LENGTH(PARSE_JSON('{"name":"Alice","age":30}'));
┌───┐
│ 2 │
└───┘