JSONParse - Prophecy Documentation

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

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. 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