> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ELT/CDC: Custom Primary Key Feature

> Use the custom primary key feature to sync tables without a primary key in Integrate.io ELT & CDC. Define surrogate keys for keyless tables.

### Prerequisite:

The table must have a unique key using NOT NULL columns. The unique key will work as the primary key for sync. 

This will only be set on the destination for Integrate.io ELT & CDC Sync.

### Getting Started

<Steps>
  <Step>
    Modify the column of your table to set a custom PK

    <Frame>
      <img src="https://mintcdn.com/integrateio/MGWLTifrhXADDsEf/images/cdc/getting-started/image-2.png?fit=max&auto=format&n=MGWLTifrhXADDsEf&q=85&s=61c79983d9464495f65ff67aeeb3150c" alt="Table column list with option to set a custom primary key" width="2428" height="222" data-path="images/cdc/getting-started/image-2.png" />
    </Frame>
  </Step>

  <Step>
    Select a column(s) that has a **unique key** and is **NOT NULL**.

    <Frame>
      <img src="https://mintcdn.com/integrateio/MGWLTifrhXADDsEf/images/cdc/getting-started/image-3.png?fit=max&auto=format&n=MGWLTifrhXADDsEf&q=85&s=15cd5949c711a3ecdf8639d0c9d8d0a3" alt="Selecting a unique NOT NULL column as the custom primary key" width="1346" height="560" data-path="images/cdc/getting-started/image-3.png" />
    </Frame>
  </Step>

  <Step>
    Once selected, hit **Save**

    <Frame>
      <img src="https://mintcdn.com/integrateio/MGWLTifrhXADDsEf/images/cdc/getting-started/image-4.png?fit=max&auto=format&n=MGWLTifrhXADDsEf&q=85&s=72a3049e75ac457183b0df503a93ac7b" alt="Custom primary key selected with Save button" width="1346" height="624" data-path="images/cdc/getting-started/image-4.png" />
    </Frame>
  </Step>

  <Step>
    Click **Continue to Sync Settings** to start the replication.

    <Frame>
      <img src="https://mintcdn.com/integrateio/MGWLTifrhXADDsEf/images/cdc/getting-started/image-5.png?fit=max&auto=format&n=MGWLTifrhXADDsEf&q=85&s=3617f9219f202d18189698f1fae1bbeb" alt="Continue to Sync Settings button to start replication" width="2668" height="804" data-path="images/cdc/getting-started/image-5.png" />
    </Frame>
  </Step>
</Steps>
