System Columns and Tables

We value transparency and want you to have complete access about what Fivetran does with your data, so we created system columns and tables, which is something like metadata about your data.

---

System columns

Wherever applicable, Fivetran adds extra columns to every table that is added to your destination, to give you insight into the progress and changes of your integration:

• _fivetran_synced (UTC TIMESTAMP) indicates the time when Fivetran last successfully synced the row.
• _fivetran_deleted (BOOLEAN) to mark rows that were deleted or the past versions of the rows changed in the source database.
• _fivetran_index (INTEGER) enables the user to make sense of the order of updates for primary keyless tables.
• _fivetran_id (TEXT) is a Fivetran-generated internal unique surrogate primary key. Its value is generated based on the row's set of values and helps us avoid duplicate rows in primary keyless tables.

When you activate history mode for a table, Fivetran adds the following three extra columns:

• _fivetran_active (BOOLEAN) to identify an active record.
• _fivetran_start (UTC DATETIME) to keep track of the time when a record is first created or modified in the source database.
• _fivetran_end (UTC DATETIME) to keep track of the time till when a record is active in the source database.

NOTE: When you activate history mode for a table, you can opt to remove the _fivetran_deleted column for that table.

---

Other system tables

Certain integrations have unique Fivetran-created system tables that give specific information about that integration. See each individual integration page for more information.

---

MAR impact

Fivetran's system tables count towards free :

• FIVETRAN_API_CALL
• FIVETRAN_FORMULA
• FIVETRAN_FORMULA_FAILURE_REASON
• FIVETRAN_FORMULA_MODEL
• FIVETRAN_QUERY
• FIVETRAN_PICKLIST_FIELD
• FIVETRAN_PICKLIST_FIELD_VALUE
• FIVETRAN_DEPENDENT_PICKLIST_RELATION

The MAR that the generates is free.