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

# JSONParse

> Extract and parse JSON from a column

export const gemName_0 = "JSONParse"

export const execution_engine_0 = "the SQL warehouse"

<Info>This gem runs in {execution_engine_0}.</Info>

## Overview

Use the JSONParse gem to extract and parse JSON from a column within your table using configurable schema detection methods for structured, usable output.

<Tip>
  The {gemName_0} gem has a corresponding interactive gem example. See [Interactive gem
  examples](/data-analysis/gems/gems#interactive-gem-examples) to learn how to run sample pipelines
  for this and other gems.
</Tip>

## Parameters

| Parameter              | Description                                                                                                                                                                                                                                                                                  |
| ---------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Select column to parse | Specifies the input column containing the JSON data to be parsed.                                                                                                                                                                                                                            |
| Parsing method         | Determines how Prophecy derives the schema used to parse the JSON structure.<ul><li>**Parse from sample record**. Prophecy uses the schema from the sample record you provide.</li><li>**Parse from schema**. Prophecy uses the schema you provide in the form of a schema struct.</li></ul> |

## Output

The output schema of the JSONParse gem includes all of the input columns and the parsed content as a **struct** data type.

<img src="https://mintcdn.com/prophecy-62973bd0/88t3kPk63E5ZR9Oi/data-analysis/gems/parse/img/json-parse.png?fit=max&auto=format&n=88t3kPk63E5ZR9Oi&q=85&s=480db7783ee3cb4ebc27778aee557314" alt="JSONParse Output" width="2866" height="1610" data-path="data-analysis/gems/parse/img/json-parse.png" />