What Is the Purpose of the fivetran_index Column?

Question

What is the purpose of the fivetran_index column?

Environment

Connector: NetSuite SuiteAnalytics

Answer

Fivetran adds the fivetran_index column to handle cases where a source table contains duplicate records, such as when:

• Multiple rows share the same primary key.
• A table has no primary key and contains identical rows.

Duplicates can cause multiple rows to receive the same fivetran_id. When this happens, we use the fivetran_index column alongside fivetran_id to uniquely identify each row. The value of fivetran_index reflects the sync order.