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

Community

Connector Improvement: Allow logical primary/key for tables without primary key in source database

Answered
Harvinder Singh User

One of our connectors is failing to load a large table because it lacks a primary key, and Fivetran cannot process it. It would be beneficial to allow us to configure a logical key for a table, even when a primary key is absent in the source system.

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Eric O'Connor Fivetranner

    Hi Harvinder,

    Thanks for writing in. Which connector is this? 

  • Harvinder Singh User

    SQL Server. 

  • Rean Fivetranner

    Hi Harvinder,

    Thanks for sharing your feedback!

    To sync tables that don’t have primary keys, I’d recommend enabling Change Data Capture (CDC) on those tables. Fivetran does support syncing primary key-less tables when CDC is enabled.

    Alternatively, we recently introduced a new method called the Binary Log Reader, which also supports syncing tables without primary keys. 

    You can find more details here in our documentation on CDC and the Binary Log Reader.

    Let us know if you have any questions or need help evaluating which approach is best for your use case.

    Best,
    Rean