# Overview

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: Overview
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-functions/json-functions/index
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-functions/json-functions/index.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/json-functions/index.adoc
description: Redpanda SQL provides functions to query and manipulate JSON data.
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/json-functions.md -->

Redpanda SQL provides functions to query and manipulate `json` data:

| Functions | Description |
| --- | --- |
| json_extract_path() | Extracts a json sub-object at the specified path. |
| json_extract_path_text() | Returns text referenced by a series of path elements in a json string or json body. |
| json_array_length() | Returns the number of elements in the outer array of a json string or json body. |
| json_array_extract() | Returns the json array as a set of json values. |

Use operators to specify conditions when using `json` functions. Redpanda SQL also supports the following `json` operators:

| Operators | Description | Example |
| --- | --- | --- |
| → | Gets and returns the element of the json array. | '[{"a":"cab"},{"b":"bac"},{"c":"abc"}]'::json → 2 |
| → | Gets and returns the json object field. | '{"a": {"b":"abc"}}'::json → 'a' |
| →> | Gets and returns the element of the json array as text. | '[11,22,33]'::json →> 2 |
| →> | Gets and returns the json object field as text. | '{"a":13,"b":33}'::json →> 'b' |