Expand my Community achievements bar.

SOLVED

no all fields fields from schema visible in dataset

Avatar

Level 8

Hi, 

I have got a question. Why not all fields are visible in dataset preview even though they are in the Schema which was used to build that dataset? Is it because some particular columns are not yet populated with data? 

I have attached default Commerce field group which has a lot properties but these properties are not populated in the dataset. 

 

Michael_Soprano_0-1701880372139.png

Michael_Soprano_1-1701880452736.png

Regards 

Mike 

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

I think it also just uses a sample of recent data to populate that preview. So, if the data in the sample didn't contain the fields you are interested in seeing, it might not display. Preview dataset is handy for a quick sanity check, but a more thorough way to validate would be to use query service to confirm fields are being populated. Or if you are validating for your own activity and things are enabled for profile, confirm that your profile has the expected events and fields in it.

View solution in original post

3 Replies

Avatar

Community Advisor

Hey @Michael_Soprano 

 

Lot of these columns you are looking at are either object types or arrays or maps which don't show up in the UI. I am not sure about the exact reason. 

 

You can try querying the dataset using query service if you believe there should be data in those columns and they should show up.

 

Let me know if you face any issues.

 

Cheers,

Abhinav

Avatar

Correct answer by
Employee Advisor

I think it also just uses a sample of recent data to populate that preview. So, if the data in the sample didn't contain the fields you are interested in seeing, it might not display. Preview dataset is handy for a quick sanity check, but a more thorough way to validate would be to use query service to confirm fields are being populated. Or if you are validating for your own activity and things are enabled for profile, confirm that your profile has the expected events and fields in it.

Avatar

Employee

Did you find the suggestion solution helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.