Monitor cirrus

metric-hub

Pre-defined data sources for monitor_cirrus. These data sources are defined in metric-hub

monitor_events_v1

Client ID column: None

Submission Date column: None

Definition:

(
    SELECT
        DATE(submission_timestamp) AS submission_date,
        e.* EXCEPT (events),
        mozfun.map.get_key(event.extra, 'user_id') as client_id,
        event
    FROM
        `moz-fx-data-shared-prod.monitor_frontend.events` e
    CROSS JOIN
        UNNEST(e.events) AS event
)

---