Warehouse Modeling and Joins

Apply modeling and joins to a dependable analytical warehouse.

112 minCourse availableLab availableQuiz available

⌘

Hands-on notebook

lab09_modeling_and_joins.ipynb

Apply modeling and joins to a dependable analytical warehouse.

1. Supported operating systems

macos, linux, wsl2

2. What you will run

The highlighted notebook is relative to the cloned repository root. Keep the full checkout because Labs can import shared helpers and reuse earlier module assets.

doris-courses/
└── doris-course/02-data-warehousing/
    └── level2/
        └── module09-modeling-and-joins/
            └── lab09_modeling_and_joins.ipynb  ← run this notebook

3. Clone, prepare, and launch

Replace <LOCAL_PARENT_DIRECTORY> with a directory on your machine. Run these commands in a local terminal, not in this website.

git clone https://github.com/velodb/doris-courses.git <LOCAL_PARENT_DIRECTORY>/doris-courses
cd <LOCAL_PARENT_DIRECTORY>/doris-courses
git checkout --detach 7056c2c75dbb2a131becc78d923d431a8b4f4e8f
cd doris-course/02-data-warehousing

python3.12 -m venv .venv
source .venv/bin/activate
python -m pip install -r requirements.txt

jupyter lab level2/module09-modeling-and-joins/lab09_modeling_and_joins.ipynb

4. Dependencies and services

Git
Docker Engine or Docker Desktop with Compose v2
Python 3.11 or newer
JupyterLab
Any external service named by the selected notebook

Module environment: Git, Docker Engine or Docker Desktop with Compose v2, Python 3.11 or newer, JupyterLab, Any external service named by the selected notebook

The commands above prepare the shared Python environment. Follow the notebook's opening checks for module-specific containers, credentials, datasets, or external services before running later cells.

View notebook on GitHub ↗