Why Is Data Missing From the EVENT Table?

Question

Why is data missing from the EVENT table?

Environment

Connector: Iterable

Answer

Iterable's API doesn't return a primary key for the EVENT table. To avoid duplication, we hash the values of the event_name, campaign_id, created_at, and email columns and include the resulting value in the _fivetran_id column. We de-duplicate events with the same _fivetran_id value.

However, simultaneously occurring events may result in the same created_at value and, subsequently, the same _fivetran_id, which may result in de-duplication and missing event data.