JSON functions

This sheet provides a quick reference guide for various JSON functions commonly used in data analysis and programming. Each function is accompanied by its syntax, a sample usage, and a brief description.

JSON_EXTRACT

The JSON_EXTRACT function extracts a value from a JSON string using a jq-like syntax.

Syntax

JSON_EXTRACT(json_string, path)

Sample

JSON_EXTRACT('{"a": {"b": "c"}}', '.a.b') => "c"
JSON_EXTRACT({json_column}, '.key')

Remark

• json_string must be a valid JSON string.
• path follows jq-like dot notation (e.g., .a.b to access nested values).
• Returns the extracted value as a string.