Surrogate key

Concept

A surrogate key is a system-generated unique identifier, often a sequential number, that is not derived from business data and is used to relate tables such as fact and dimension tables.

Title graphic: Surrogate key (Concept)

Type	Concept
Wikipedia	en.wikipedia.org/wiki/Surrogate_key

Episodes about Surrogate key

Build a Power BI Star Schema for Faster Reports

2025-11-03 · Video on YouTube

when people first open power bi, they usually jump straight into visuals. charts, slicers, maps—it feels like that’s where the real action is. but the longer you work with it, the more you realize that the real magic is happening underneath, in the way the…

Articles about Surrogate key (1)

Mastering Power Query: Transforming Flat Data into a Star Schema
2026-08-12 · Mirko Peters
Welcome back to the podcast companion blog! In today's post, we are diving deep into the technical mechanics of data modeling. If you have ever inherited a massive,…

Glossary

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.

Sources

Wikipedia: en.wikipedia.org/wiki/Surrogate_key
Feed for this topic (RSS): entity/surrogate-key/feed.xml
M365.FM episodes on this topic: 1
Articles on this topic: 1

Maintained by Mirko Peters (Microsoft MVP) · Last updated: 2026-11-03