DiamondDisney Pinnacle Flow_Events Event Examples
    Updated 2024-12-09
    SELECT
    event_contract,
    event_type,
    count(distinct tx_id) as event_ct,
    any_value(event_data) as event_data
    FROM
    flow.core.fact_events
    WHERE
    EVENT_CONTRACT = 'A.edf9df96c92f4595.Pinnacle'

    -- and event_contract ilike '%edf9df96c92f4595%'
    group by 1, 2