Question
Why are there duplicate sg_event_id values?
Environment
Connector: SendGrid
Answer
The sg_event_id is not a primary key and we may receive multiple records with the same event_id value. Each event is synced and a primary key, _fivetran_id, value is created for the new event. This value is a composite of other field values in the record.
The latest value will be the latest value for that event_id.