JSON Parser Processor
The JSON. parse() method parses a JSON string, constructing the JavaScript value or object described by the string.
Processor Configuration
Input JSON Column
Provide the column name for which JSON data will be parsed.
Schema
Select Infer Schema option to infer the schema from the JSON or select Specify Schema option to specify the schema under the JSON Schema field.
JSON Schema
Specify JSON schema.
Example: field1 INT, Country string, is_valid boolean, field2 DECIMAL(8,2)
Allow unquoted JSON field names
Check mark the option to allow parsing of unquoted JSON field names.
Allow single quoted JSON field names
Check mark the option to allow parsing of single quoted JSON field names.
Additional properties can be added using ADD CONFIGURATION link.
If you have any feedback on Gathr documentation, please email us!