Field in UNION Schema missing from Profile_Snapshot | Community
Skip to main content
G
GabrielaNa1
Level 4
February 19, 2026
Question

Field in UNION Schema missing from Profile_Snapshot

  • February 19, 2026
  • 3 replies
  • 24 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:

Profile/Browse

in Union Schema:

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?

    3 replies

    arpan-garg
    Community Advisor
    arpan-gargCommunity Advisor
    Community Advisor
    February 19, 2026

    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
    February 19, 2026

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

     

    arpan-garg
    Community Advisor
    arpan-gargCommunity Advisor
    Community Advisor
    February 20, 2026

    ​@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
    February 20, 2026

    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
    itsMeTechy
    Level 4
    February 23, 2026

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...