v.21.11New Features

Added JSONExtractKeys Function

Added JSONExtractKeys function. #30056 (Vitaly).
Added the JSONExtractKeys function to ClickHouse.

Why it matters

This function allows users to extract the keys from a JSON object, enabling easier inspection and manipulation of JSON data stored in ClickHouse tables.

How to use it

Invoke the JSONExtractKeys function by passing a JSON string or column containing JSON data, for example:

SELECT JSONExtractKeys(json_column) FROM table_name;

This will return an array of keys present in the JSON object.