Category: Data Engineering how-tos
-
Surrogate keys in dimensional data modeling – why, when, and how (dbt and BigQuery)
The why. A surrogate key (SK) is a type of unique identifier for a row in a database which decouples any relations from the source data and becomes the primary identifier in the data warehouse. And in the case of dimensional data modeling they are the foreign keys (FK) in the facts tables. From here…