Skip to main content
This gem runs in .

​
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.
The gem has a corresponding interactive gem example. See Interactive gem examples to learn how to run sample pipelines for this and other gems.

​
Parameters

ParameterDescription
Select column to parseSpecifies the input column containing the JSON data to be parsed.
Parsing methodDetermines how Prophecy derives the schema used to parse the JSON structure.
  • Parse from sample record. Prophecy uses the schema from the sample record you provide.
  • Parse from schema. Prophecy uses the schema you provide in the form of a schema struct.

​
Output

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