How to Query an Audience using Query Service?

[montezh2001]

All, 

I just need help on how I can run an query on an Audience I created, but I want to use Query Service so I can confirm some values from the Audience.

I've run queries on the datasets using a Journey Action ID to get Tracking/Message feedback information, but I don't see any documentation on how to run this type of query on an actual audience. 

Please advise. 

[Mohan_Dugganab · Accepted solution]

You can query the profile snapshot system dataset to find out the qualified profiles against your audience.

SELECT count()
FROM profile_snapshot_export_ID -- replace export id
WHERE segmentMembership['ups']['segment ID'] IS NOT NULL
AND segmentMembership['ups']['segment ID']['status'] IN ('realized')

References 

https://experienceleague.adobe.com/en/docs/experience-platform/dashboards/query 

https://experienceleaguecommunities.adobe.com/t5/real-time-customer-data-platform/profile-snapshot-a...