Can I Specify a Primary Key for a Table Within Fivetran?

Question

Can I specify a primary key for a table from within Fivetran, or must I define it in the source SQL Server database?

Environment

Connector: SQL Server

Answer

No, you can't set or override a table's primary key in Fivetran. You must define the primary key in the source SQL Server database.

We use the primary key defined in the source database for change capture and merge operations. If a table doesn't have a primary key, we use a system-generated identifier, such as _fivetran_id. For more information, see Tables Without a Primary Key and System Columns and Tables.