Data Model Design 101: Composite vs Surrogate Keys

When to know which type of key to use in your data models

Madison Schott
Towards Data Science
4 min readFeb 9, 2024

--

Photo by Jason D on Unsplash

I’ve recently been writing a data model to represent a new part of our business. The data requires a lot of questions to be asked, as it’s quite difficult to understand intuitively.

--

--

Analytics Engineer @ ConvertKit, author of the Learn Analytics Engineering newsletter and The ABCS of Analytics Engineering ebook, health & wellness enthusiast