Skip to main content

JSONParse

SQL

The JSONParse gem lets you parse JSON that is included in a column of your table.

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