Integration Challenges with Mixpanel and GBQ: Resolving Distinct IDs
We are integrating mixpanel with GBQ and we are considering the unique identifier as resolve distinct id using the below query.
SELECT
CASE
WHEN m.resolved_distinct_id IS NOT NULL THEN m.resolved_distinct_id
WHEN m.resolved_distinct_id IS NULL THEN e.distinct_id
END as resolved_distinct_id,
COUNT(*) AS count
FROM mixpanel_nessie_day_partitioned_<PROJECT_ID>.mp_master_event e FULL OUTER JOIN mixpanel_nessie_day_partitioned_<PROJECT_ID>.mp_identity_mappings_data_view m
ON e.distinct_id = m.distinct_id
AND mp_city="San Francisco"
AND DATE(e._PARTITIONTIME) <= "2024-12-03"
AND DATE(e._PARTITIONTIME) >= "2024-12-01"
GROUP BY resolved_distinct_id
LIMIT 100However, there are multiple resolve_distinct_id values for which we need to retrieve the UUID and Email fields. The challenge we are facing is that we are unable to locate the resolve_distinct_id in the Mixpanel interface.Could you kindly let me kn0w why it is happening?