What Are the _fivetran_index and _fivetran_id Columns in the Destination Schema?

Issue

What are the _fivetran_index and _fivetran_id columns in the destination schema?

Environment

Destinations

Resolution

Fivetran creates the two system columns to work with the tables without a primary key:

• _fivetran_index (INTEGER) enables the user to make sense of the order of updates for tables without a primary key.
• _fivetran_id (TEXT) is a Fivetran internal unique id that helps us avoid duplicate rows in tables without a primary key.

For more information about system columns, see our documentation.