Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: [Iterable] Include true primary key in events table

Answered
Meera Temple User

Hi!

I'm missing some rows in my events table, and after speaking with the Support team, they suspected it was because Iterable didn't provide a unique event ID.

I learned that the current Fivetran ID is a hash of the following fields in the event table: EVENT_NAME, EMAIL, CAMPAIGN_ID, CREATED_AT.

Our company sends the same campaign out to certain subscribers every few weeks, which means that the Fivetran ID is not necessarily unique for our situation.

My request is a true unique event ID so that data doesn't get lost!

 

Thanks,

Meera

 

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Drew Fivetranner

    Hi Meera, Drew from the Product Team here!

    Thanks for this feature request! This is definitely a challenge with Iterable (and other event based platforms) that do not provide a primary key.

    Out of curiosity, are there additional fields you would add to the primary key that would help uniquely identify your events?