Duplicate sg_event_id Values

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 value for the primary key, _fivetran_id, is created for the new event. This value is a composite of the other field values in the record.

The latest _fivetran_id value will be the latest value for that event_id.