how to find which profile attribute is contributed by which dataset ?

[Pradeep-Jaiswal]

lets say i have primaryemailid as an attribute in the profile. i want to make an upsert or overwrite on that dataset. but before i do that, i want to trace which dataset contributed to that attribute in profile store. how do i find that dataset ?

[itsMeTechy]

When you navigate to the union schema, search for an attribute, and click on it, you can see which dataset(s) contribute that attribute to the union schema. If multiple datasets contribute to the same attribute, all of them will be displayed.

However, when multiple datasets contribute to the same attribute, determining which dataset the attribute is currently referenced in the profile store can be a bit tricky. While it’s possible to identify this manually by querying the datasets, it’s unclear if there’s a more efficient way to find this information.

[Pradeep-Jaiswal]

Union schema shows list of schema contributing to it, but the dataset name list are misleading. I have checked it also shows those list of dataset, which doesnt even have those fields. it could be a bug in the UI ? Or may be it assumes that just if the underlying shema has the field, then dataset might also have it ?

By the way I have tried these steps in past ,

- From union schema find the list of schema contributing to that field

- From dataset, find all those schema which are linked to it. using the filter on bottom left corner. This would be one schema filter at a time.

- Then query each of the dataset to see if they have a column for that attribute. Having a column indicates that dataset contributed toward the data ingestion for that field.

[Sukrity_Wadhwa]

Hi @itsMeTechy,

Can you please help @Pradeep-Jaiswal further with their query?

Thanks!

[itsMeTechy]

When an attribute belongs to one or more schemas, the union schema displays all those schemas and their corresponding datasets as contributing sources irrespective of whether you have ingested data in all the respective datasets or not.

For an attribute when data is ingested in multiple datasets—either within a single schema or across multiple schemas—and you need to determine which dataset’s record is currently represented in the Profile Store, you must refer to the merge policy configuration and use the Query Service to identify the dataset whose record is currently being referenced. As far i know there is no OOTB way to determine the dataset whose data is referenced in profile store.