I have incoming data from SnowFlake in which one column ("SEGMENT_QUALIFICATION") is an array of objects. Below is the screenshot of the same:
I am using the SnowFlake connector and during the ingestion mapping step, I am using the "json_to_object" function to map it to the XDM fields that I have created and this is how it looks in the mapping step:
The dataflow is running, but I am not getting data in the target column - "custSegmentMembership" (the object is NULL when I query it after the run). I tried to use other mapper functions, but those were unsuccessful. Any insights on how to ingest it would be much helpful. Thanks in advance.
Below is how the schema is created:
Solved! Go to Solution.
@jainarundeep Thanks for this. I tried just "custSegmentMembership" (the parent object without the "[*]") and it worked. I will also try the option that you had mentioned. Is there any best practice or recommendation here ( whether to use [*] or not)?