JSON_ARRAY
Learn how to use the JSON_ARRAY json function in PlaidCloud Lakehouse. Creates a JSON array from a list of values - see syntax, examples, and output.
Creates a JSON array from a list of values.
Analyze Syntax
func.json_array(1, 'hello', None)
Analyze Examples
func.json_array(1, 'hello', None)
┌──────────────────┐
│ [1,"hello",null] │
└──────────────────┘
SQL Syntax
JSON_ARRAY(1, 'hello', None)
SQL Examples
SELECT JSON_ARRAY(1, 'hello', NULL);
┌──────────────────┐
│ [1,"hello",null] │
└──────────────────┘