Paths/Data Engineer/Data Transformations / Models & Projects
Write a Staging Model
A staging model is a view that renames, casts and nothing else. Write one that the rest of the warehouse can rely on.
Validator
⏱ 0:00
IDLE — checks run live as you type commands; submit when done
01Requirements
live checks- Directory ~/dbt/models/staging exists○
- File ~/dbt/models/staging/stg_orders.sql exists○
- The model renames the raw columns and casts the types○
- The model selects from the source with a ref○
02Walkthrough
1 of 3 revealed- 01
Create the models directory
Staging models live in their own folder, one folder per layer.
mkdir -p ~/dbt/models/staging - 2 locked · each failed submit reveals one
03Stuck?
0 of 3 revealedTake a hint without losing the lab — each one points at the thing to look at, not at the answer.
04AI Tutor
guides, never solvesTell me what you're stuck on — I'll nudge, not solve. Which requirement are you looking at?
04Notebook
saved locally in this browserlearner@lab — ubuntu:24.04
Session is disposable
↑/↓ recalls commands · Ctrl+Enter submits · type help for the command list