URGENT HELP NEEDED! Query Service on a Snapshot dataset for a specific audience
All,
Has something changed with the Snaphot dataset, specifically the segmentMembership. The following Query used to work for me, but no longer does:
SELECT
channel,
COUNT(*) AS eventCount
FROM
(
SELECT
EXPLODE (_cocacola.communicationChannel.channel) AS channel
FROM
profile_snapshot_export_c495eb9a_5571_46e2_9ccd_310042dddc72 SNAPSHOT AS OF 1588
WHERE
segmentMembership['ups']['a0bd3286-e38c-4c44-b037-d2f9d8a2cf81']['status'] IN ('existing', 'realized', 'exited')
) AS exploded
GROUP BY
channel
I pulled the most current ID and then searched for the segmentID of the audience I need to take a count on, but I get 0 returns now. Does anyone know what’s changed?