Audience population - profile snapshot - users are not returned

[Michael_Soprano]

I use basic query to find a profiles which belong to audience (80k users). 

Why nothing is returned?? No error

SELECT *
from profile_snapshot_export_745b62c8_332c_4a79_970e_03660f18b752
WHERE segmentMembership.DDA['22eb5450-7b52-4d42-a9bc-e5dea5d34955'] IS NOT NULL

why on our demo sandbox I need to use segment.membership.ups ???

[brekrut]

Hello @Michael_Soprano,

To locate the membership of an audience you can use the following SQL statement.

select * from profile_snapshot_export_XXXXX where segmentmembership['ups']['<<segmentID>>'].status IN ('realized'). -- this is for profiles which qualify for the segment.

The segment object is a array object.  This is why you will need to use format in the above example.

[Michael_Soprano]

@brekrut do you know what is the difference between DDA and UPS 

[brekrut]

Hello @Michael_Soprano 

Here is the breakdown of the terms.

UPS is Unified Profile Store

DDA is Data Distiller Audience