Is there a way to query a look a like audience ?

[JuanOrozco_96]

Hello community, currently I'm trying to query a look a like audience in experience platform but when I use the condition  

"array_contains(map_keys(segmentMembership['ups']), 'audienceID')"

there is no information displayed. Is there a way to commit this query or is not possible at moment ?

[supratim320]

Is it possible to share the whole query?

[supratim320]

I gave it another try, it works for me. If it is not working for you, then can you ensure that your audience contain some profiles?

Sample query that run successfully for me:

SELECT * FROM 
(SELECT array_contains(map_keys(segmentMembership['ups']), 'audienceId') as TEST_COL, workEmail.address
FROM profile_snapshot_export_abc)
WHERE TEST_COL = True

[kautuk_sahni]

@JuanOrozco_96 Just checking in — were you able to resolve your issue?
We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!