json_object_keys
function
Applies to: Databricks SQL Databricks Runtime
Returns all the keys of the outermost JSON object as an array.
Syntax
json_object_keys(jsonObject)
Arguments
jsonObject
: A STRING expression of a valid JSON array format.
Returns
An ARRAY < STRING >.
If 'jsonObject' is any other valid JSON string, an invalid JSON string or an empty string, the function returns NULL.
Examples
> SELECT json_object_keys('{}');
[]
> SELECT json_object_keys('{"key": "value"}');
[key]
> SELECT json_object_keys('{"f1":"abc","f2":{"f3":"a", "f4":"b"}}');
[f1,f2]