Field in UNION Schema missing from Profile_Snapshot

Forum|Forum|25 days ago
February 19, 2026
4 replies
42 views

Hi, I am having a field which is present in the Union schema and it has values for a number of records. I can see it all right in the profile:

in Union Schema:

But if I run this query on the profile snapshot:

SELECT to_json(_myTenantName)
FROM profile_snapshot_export_66aefd28_7113_489a_a40f_b7fa9efe34e5 AS p
WHERE p._deloittellpcanada.partyIdentifier.CID= '111613'

I get this - no SuppressionID_List:

Any idea why is that and how can I get all fields into the Profile Snapshot?

Best answer by GabrielaNa1

Thank you all for your replies. This was not a data or configuration issue on our end. It is solved now, but we needed a ticket to support. It seems that the problem was some glitch in Adobe. The support team recreated the snapshot from the backend and now I can see everything just fine.

arpan-garg

Community Advisor

Hi @GabrielaNa1 - When were these fields ingested? Profile snapshot is updated at a certain time in last 24 hrs(ofcourse this can be configured). It is possible that those fields are added today and the profile snapshot is not yet updated.

Thanks,

Arpan

G

GabrielaNa1Author

Level 4

The field was ingested a few days ago, I don’t think that the recency is the cause. Thanks.

arpan-garg

Community Advisor

@GabrielaNa1 - Are you facing this issue with all the profiles in profile snapshot or only that certain profile which you mentioned in screenshot

G

GabrielaNa1Author

Level 4

The field just doesn’t show in the json - It looks like it doesn’t exist:. If I try to run some query like this:

select _deloittellpcanada.adcCIDOtherAttrADS.SuppressionID_List, count(*)
from profile_snapshot_export_66aefd28_7113_489a_a40f_b7fa9efe34e5
group by _deloittellpcanada.adcCIDOtherAttrADS.SuppressionID_List

I get this error:

ErrorCode: 08P01 queryId: 4e968b16-a9df-4dab-9828-d76d5caf1dc3 Unknown error encountered. Reason: [[FIELD_NOT_FOUND] No such struct field `suppressionid_list` in `InterfaceID_in_CS`, `PCU_RowID_in_CS`, `Language`, `InterfaceID_List`, `Name_Business`.; line 6 pos 9]

So I believe the answer is yes, it affects all profiles.

itsMeTechy

Level 4

how many merge policies you have in your sandbox? do you use any data set precedence merge policy?

if there are multiple merge policy, then there will be that many profile snapshot dataset and you need to refer correct snapshot table.

G

GabrielaNa1Author

Level 4

We only have the default merge policy, so only one profile snapshot.

itsMeTechy

Level 4

ok. am assuming you have this field in individual profile class schema.

if you see data when you do profile lookup. but not showing up in profile snapshot is weird. another possibility am thinking is that the batch which ingested this record might be deleted. Deleting a batch from the respective dataset wont remove it from profile store, it only removes it from data lake.

Suggest you to re-ingest the data for another identity. wait for the data to get processed to profile store and to the snapshot dataset. check if it comes up fine. if it doesn’t, then you can check with adobe support with all the details.

G

GabrielaNa1AuthorAccepted solution

Level 4

Thank you all for your replies. This was not a data or configuration issue on our end. It is solved now, but we needed a ticket to support. It seems that the problem was some glitch in Adobe. The support team recreated the snapshot from the backend and now I can see everything just fine.