Forum Discussion
I am trying to extract the values including the array list and load into Snowflake. Below are the fields
abandoned
abandonSeconds
acwSeconds
agentId
agentSeconds
tagid
tagname
Attached below is a sample pipeline that will flatten on tags array, so for every element in the tag array you will have a document with the above information from the parent contacts object.
Let me know if this is what you are trying to achieve.
Regards,
Aleksandar.
This worked perfectly fine. I do have questions though,
1) will this methodology work for multiple tags(arrays)?
2) Adding the second JSON splitter makes it easier, I did provide a small number of columns in the sample but it has lot morefields. If we have to add 100's of fields it becomes tedious. Is there another option or an easier way to do this?- Aleksandar_A2 years agoContributor III
Hello GanguP,
You can try before splitting the tags array, to map it to include all of the parent fields in a Mapper Snap then split it.
And about the first question, I'm not sure if I understand it, so could you please clarify it?
Let me know if this helps.
Regards,
Aleksandar.
You can refer to the attached pipeline below.