Expand my Community achievements bar.

Join Adobe Experience Platform experts for a live Ask Me Anything on September 2nd at 8 AM PT!
SOLVED

Schema Creation issue

Avatar

Level 2

I have gone through the document and I am able to understand how to create a schema. I am practicing it on Sandbox.
Now I have added few fields which went under an Object datatype name : _adobecincoptrsd
Screenshot 2025-08-07 at 10.39.22 PM.png

 

Once, I am able to ingest the data in the schema it is successful but when I query it, it give me something like this:

Screenshot 2025-08-07 at 10.38.39 PM.png
But as per my understanding this data is making no sense as a new user will not be able to understand this. 
What are the possible solutions to get this type of data in the form of rows and columns? 
Thanks! In Advance.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Prabhakar_The_Analyst  - Yes this is how you see the data in datasets when you query them. What do you mean by saying that the user will not be able to understand the data? Who is the user here?

 

Thanks,

Arpan

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

Hi @Prabhakar_The_Analyst  - Yes this is how you see the data in datasets when you query them. What do you mean by saying that the user will not be able to understand the data? Who is the user here?

 

Thanks,

Arpan

I mean the say the analyst who in case query the table from query editor.
Thanks for the reply Arpan. 
The query has been resolved. Thank you so much!

Avatar

Community Advisor

Hi @Prabhakar_The_Analyst ,

When you use query service and use "select *" in your query it returns the first level of hierarchies in the XDM. If there are multiple sub-fields under the first level hierarchy it will show up values from all the sub-fields in a curly brackets as shown in your screen shot.

To get any specific field you'd have to provide their complete path. In your example schema, if you are trying to read "Gender" then your query should have "select _adobecincoptrsd.EL_Demo_Details.gender" and so on for rest of the fields. With this each of these fields will show up as separate columns in query results.

Cheers!

Hi @Harveer_SinghGi1, Thanks for this explanation. Got that.