When Segment runs historical backfills:

- The`id_graph_updates`,`external_id_mapping_updates`,and`profile_traits_updates` tables sync your entire historical data to your warehouse.

- The`id_graph_updates`and`external_id_mapping_updates` tables sync your entire historical data to your warehouse.

- Profiles Sync gathers the last two months of all events, including those from the`identities`,`page`,`screens`, and`tracks` tables, and syncs them to your warehouse.

Segment lands the data on an internal staging location, then removes the backfill banner. Segment then syncs the backfill data to your warehouse.

In this table, Segment shows three observed identifiers. For each of the three identifiers, Segment outputs the Segment ID initially associated with the identifier.

The`profile_traits_updates` table maps each`segment_id` with all associated profile traits.

Segment updates this table:

- for each identify call that updates one or more traits for a`segment_id`.

- for any merge where traits from two previously separated profiles are now combined.

In the event that two profiles merge, Segment only updates the`profile_traits_updates` table for the`canonical_segment_id`, or the fully merged id.

From the`profile_traits_updates` table, use Segment's[open-source dbt models](https://github.com/segmentio/profiles-sync-dbt){:target="_blank"}, or your own tools to materialize the[`profile_traits`](#the-profile-traits-table) table with all profiles and associated profile traits in your data warehouse.