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