The Ancestry_EthnicityRegion table is a lookup that gives each ethnicity region a human-readable name and ties it to a parent macro-region. It is keyed by regionKey, the same identifier stored in Ancestry_MatchEthnicityRegion, so the two tables join to turn a region code and percentage into a readable breakdown such as “Southern Germanic Europe.”
| Column | Type | Source | Description |
|---|---|---|---|
| regionKey | string (PK) | Match Compare | Region identifier — the join key used by Ancestry_MatchEthnicityRegion |
| regionDisplayName | string | Match Compare | Human-readable region name (e.g., “Southern Germanic Europe”) |
| macroRegionKey | string | Match Compare | Identifier of the broader macro-region this region belongs to |
| macroRegionDisplayName | string | Match Compare | Human-readable macro-region name |
| version | int | Match Compare | A*’s ethnicity estimate version that produced this region |
Rows are upserted by regionKey during the Origins comparison on a match’s compare page, alongside the per-match percentages in Ancestry_MatchEthnicityRegion. Because it is keyed by the region, the table stays small — one row per region regardless of how many matches reference it — and each gather refreshes the stored name and version.
regionKey.