What is One Big Table? Exploring When to Use it, When Not to Use it and My Personal Experience

Unlocking Data Potential: Simplify and Supercharge Analytics with One Big Table design

Tech Zero
5 min readDec 14, 2023

In my data engineering feed on LinkedIn, Medium, Reddit etc., I started noticing a lot of attention being given to designing tables as One big table (OBT).

Image credit — https://www.alphaservesp.com/blog/what-is-sql-database-structure-types-examples

If you haven’t heard about it before, it isn’t inherently a new concept/idea in data engineering. It has been used in data modeling for many years, particularly in scenarios where simplicity and performance are prioritized. However, it seems a lot of data engineering team across organizations are adopting this approach.

What is One Big Table?

OBT is a modelling technique where all the data attributes needed for analytics are stored into one, wide, denormalized table. Unlike the traditional data models such star schema, snowflake schema, OBT eliminates the need to join data between dimension and fact tables. This means all the columns your Power BI/Tableau/data analyst/data science team would need are available in one table as opposed to being split between dimension and fact tables.

Visual representation

--

--

Tech Zero
Tech Zero

Written by Tech Zero

Product Manager, Data & Governance | Azure, Databricks and Snowflake stack | Here to share my knowledge with everyone

Responses (2)