dominator_pote_ny

Find all events that have a 'country' property defined

For each event, list the names of all its properties as prop_names and count how many properties it

Group events by the 'source' field extracted from payload using JSON_EXTRACT_SCALAR

Find button click events and extract the button_id from the payload JSON column.

For each event, return event_id and its tags sorted alphabetically with duplicates removed.

For each event, remove duplicate tags and return the event_id, the deduplicated tags, and the count

For each event, return the event_id, its first tag, and whether the tags include 'mobile'.

Count the number of tags for each event using CARDINALITY, and only include events that have more th

Low Uptime Services

From event_data, return event_id and JSON_EXTRACT_SCALAR(properties, '$.os') as os