Models, sources, tests, and documentation in dbt. The transformation layer that makes your data warehouse reliable, testable, and understandable by the whole team.
Models, sources, tests, and documentation in dbt. The transformation layer that makes your data warehouse reliable, testable, and understandable by the whole team.
Day 4 of Data Modeling in 5 Days pushes into advanced territory. You have enough foundation now to tackle real-world complexity. Today's exercise is more open-ended than earlier days — that's intentional.
Understanding document model is the core goal of Day 4. The concept is straightforward once you see it in practice — most confusion comes from skipping the mental model and jumping straight to implementation. Start with the model, then write the code.
# document model — Working Example
# Study this pattern carefully before writing your own version
class documentmodelExample:
"""
Demonstrates core document model concepts.
Replace placeholder values with your real implementation.
"""
def __init__(self, config: dict):
self.config = config
self._validate()
def _validate(self):
required = ['name', 'type']
for field in required:
if field not in self.config:
raise ValueError(f"Missing required field: {field}")
def process(self) -> dict:
# Core logic goes here
result = {
'status': 'success',
'topic': 'document model',
'data': self.config
}
return result
# Usage
example = documentmodelExample({
'name': 'my-implementation',
'type': 'document model'
})
output = example.process()
print(output)
adjacency list is the practical application of document model in real projects. Once you understand the underlying model, adjacency list becomes the natural next step.
time-series rounds out today's lesson. It connects document model and adjacency list into a complete picture. You'll use all three concepts together in the exercise below.
Extend today's exercise by adding one feature that wasn't in the instructions. Document what you built in a comment at the top of the file. This habit of going one step further is what separates engineers who grow fast from those who stay stuck.
The foundations from today carry directly into Day 5. In the next session the focus shifts to Data Vault and Enterprise Modeling — building directly on everything covered here.
Before moving on, verify you can answer these without looking:
Live Bootcamp
Learn this in person — 2 days, 5 cities
Thu–Fri sessions in Denver, Los Angeles, New York, Chicago, and Dallas. $1,490 per seat. June–October 2026.
Reserve Your Seat →