Meltano

image.png

meltano.yml

[tap-mongodb target-postgres]
My objective is made a flattening of properties from mongo and insert inside of postgres database with colunar reference, commom properties I can do that  but with arrays the tap just bring to me a string with the array content.

This is a piece of values on record stream, the field "series__intervals" is my problem

```"series__@type":"MachineMeasurement$Series",
"series__intervals":"[{\"@type\":\"MachineMeasurement$Series$Interval\",\"intervalStartDate\":\"2023-06-22T19:00:00.000Z\",\"intervalEndDate\":\"2023-06-22T19:59:59.999Z\",\"buckets\":.......```
What I need for flattening the array who is inside my document (on the image atached) ?

I'm think if that's not possible (unflatten of array) what I will need is make a custom mapper for resolve that
Like that
<https://github.com/meltano/squared/blob/e98bc42ea3a39dffa65d36b84052e1b5e318926b/data/mappers/mappers.meltano.yml>

<https://github.com/pnadolny13/mapper-generic>