Solved

Ingesting JSON Array column from SnowFlake into profiles

Forum|Forum|2 years ago
July 14, 2023
1 reply
1879 views

Hello All,

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:

Experience Platform

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by jainarundeep

@pradeep_nextrow I see you used custSegmentMembership[0], whereas it should be custSegmentMembership[*]. Let me know if this helps

J

jainarundeep

Accepted solution

Adobe Employee

@pradeep_nextrow I see you used custSegmentMembership[0], whereas it should be custSegmentMembership[*]. Let me know if this helps

pradeep_nextrowAuthor

@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)?

U

user1065

@pradeep_nextrow : I am trying to perform same thing (mapping snowflake Array column to AEP), but AEP is reading it as a string and giving error. Is it possible to share how you created: "json_to_object" function that you mentioned above?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded