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

Community

Connector Improvement: Email Connector add primary key

Answered
Doug Read User
  • Edited

It would be helpful to be able to add a primary key for the Email Connector. Sometimes the line number of the row will change.

An alternative approach would be to be able to remove the data in the destination first, then load with the new data. Could you do that with a transformation?

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Kevin Kim Fivetranner

    Hi Doug,

    Thanks for your feedback here. I am curious what files you are using with the email connector and what the primary keys would be? One difficulty is that it may be hard for us to infer what the PK is, and selecting it manually may not be the best user experience.

    I will share this request with the team, although we do not have a plan to implement this improvement at this time.

  • Doug Read User

    It is a csv right now. Would be interesting to just have a csv loader which either takes a column index or name and use that as the primary key. We can’t remove the data since the loading data may or may not contain all the records.