Skip to main content
Documentation
Feature Requests Trust Center Status Page

Community

Connector Improvement: SFTP Connector - Ability to define Unique Key

Completed
Kishor Newadkar User

We load transactions from Workday via SFTP (CSV file) and often there can be data which gets updated and would like to sync.

We need ability to define unique key so that there is UPSERT operation if we send same transaction 

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Alison Fivetranner
    • Edited

    Hi Kishor,

    I'm please to let you know that support for defining the Primary Key to be used during upsert is now available for our SFTP connector - please contact Fivetran support to join the Beta.

    Best regards

    Alison

  • Alison Fivetranner
    • Edited

    Hi Kishor

    Thank you for taking the time to share your use case and need with us. We are currently reviewing what it will take to add support for selection of primary keys for our file connectors including SFTP. We do not yet have a date for when this functionality will be available. Upvotes will always help us with our prioritization.

    Best regards

    Alison