Query all members of a audience

[DiegoMo5]

Hello there, 

Any way to query all the members from one particular audience?
I know just to check if a members is part of one particular audience and, furthermore the sample data is not enough

thanks for the help!

[SatheeskannaK · Accepted solution]

@DiegoMo5 Use this query and modify it based on your needs.

select to_json(identityMap['email']['id']), to_json(segmentMembership['ups']['<<segment_id>>'])
from profile_snapshot_export_<<snapshot_id>>
where segmentMembership['ups']['<<segment_id>>']['status'] in ('existing', 'realized', 'exited')

[DiegoMo5]

Thank you very much @SatheeskannaK

It is working as expected, the existence of the table "profile_snapshot_export" was the piece of cake

query = "SHOW TABLES LIKE 'profile_snapshot_export_%';"

[AnkitJasani29]

Hi @DiegoMo5 ,

Agree with @SatheeskannaK 's response. For more information, you can visit https://experienceleague.adobe.com/en/docs/experience-platform/query/home