Hevo gives you an option to choose how to parse Nested JSON Fields in events while creating a Pipeline with MongoDB source.
You can choose between the following options while creating the Pipeline:
- Flatten JSON fields - The event will be flattened and nested JSON fields will be merged with the top level fields. The names of the flattened fields will carry a period(.) to mark the parent field from which they are coming from.
- Split JSON fields - The event will be split and nested JSON Fields will be ingested as child events to the original event. The child events will carry a property _hevoref_id representing the identifier of the original event.
- Collapse JSON fields - Nested JSON fields will be collapsed and serialized as JSON string.
These options will be extended to other sources as well in the future. Stay tuned!