W06Advanceddeduplication · ROW_NUMBER

Deduplicate source events

Deduplicate usage_events by source_event_id, keeping the most recently ingested row. Return source_event_id, event_id, and ingested_at only for source IDs that had duplicates. Sort by source_event_id.

Data available

Use this table

1 table

Table 1

usage_events

Product events with late and duplicate source records.

event_idintegerPK
source_event_idtext
user_idintegerFK
customer_idintegerFK
event_typetext
occurred_attimestamptz
ingested_attimestamptz
duration_msintegerNULL
metadatajsonb

Query editor

PostgreSQL

⌘↵ Run query

Result stream

Output

Run your query to inspect its result.

Contextual coach

Ask about this attempt

Run or check a query first. The coach only comments on a real error or grader mismatch.

Field notes

Hints & explanation

Try to solve it cold. Two progressive hints are available.