Meltano

How can we achieve multilevel JSON mapping to target, I have a use case where I get different data(Muti level) from multiple sources which need to be mapped to a target JSON format(constant multi-level)

My sense is you'll need a custom tap for that

I tried it, and using Stream Maps I was able to create an output which is flat root-level JSON

now the challenge is my target needs it as JSON which maps this flat data at different levels in json

I am trying to figure out to build this as a target

do you know any article which will give me good start to build a target like this or in general to build a target

Maybe <https://jove.medium.com/build-a-meltano-target-within-1-hour-7134df6244fb>?

Yep started with it scratched my brain a couple of times to debug, but I landed well now, will explore more.