Skip to main content
Level 4
May 28, 2026
Question

URGENT HELP NEEDED! Query Service on a Snapshot dataset for a specific audience

  • May 28, 2026
  • 0 replies
  • 7 views

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?