> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# JSON functions

> Parse JSON, extract values from it and build JSON output.

Parse JSON, extract values from it and build JSON output.

| Function | Type | What it does |
| - | - | - |
| [`from_json`](/query/sql/functions/json/from_json) | Scalar | Parses JSON text according to a literal SQL schema. |
| [`get_json_object`](/query/sql/functions/json/get_json_object) | Scalar | Extracts a JSON value from text using a path. |
| [`get_path`](/query/sql/functions/json/get_path) | Scalar | Extracts a value from a VARIANT using a path and returns it as VARIANT. |
| [`json_extract`](/query/sql/functions/json/json_extract) | Scalar | Extracts a JSON value from text using a path. |
| [`json_extract_scalar`](/query/sql/functions/json/json_extract_scalar) | Scalar | Extracts a scalar value from JSON text as a string. |
| [`json_format`](/query/sql/functions/json/json_format) | Scalar | Compacts and normalizes valid JSON text. |
| [`json_value`](/query/sql/functions/json/json_value) | Scalar | Extracts a scalar value from JSON text as a string. |
| [`parse_json`](/query/sql/functions/json/parse_json) | Scalar | Parses JSON text into a VARIANT value. |
| [`to_json`](/query/sql/functions/json/to_json) | Scalar | Serializes a SQL struct, array or map value to JSON text. |
| [`try_parse_json`](/query/sql/functions/json/try_parse_json) | Scalar | Parses JSON text into a VARIANT value and returns NULL for per-row parse failures. |
| [`try_variant_get`](/query/sql/functions/json/try_variant_get) | Scalar | Extracts a VARIANT value at a path and converts it to a requested SQL type. |
| [`variant_get`](/query/sql/functions/json/variant_get) | Scalar | Extracts a VARIANT value at a path and converts it to a requested SQL type. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.