Table Properties, Materialized Views, and Indexes

Apply properties, materialized views, and indexes to an Apache Doris observability workflow.

85 minCourse availableLab availableQuiz available

⌘

Hands-on notebook

lab06_properties_mv_index.ipynb

Apply properties, materialized views, and indexes to an Apache Doris observability workflow.

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/03-observability/
    └── level2/
        └── module06-property-mv-index/
            └── lab06_properties_mv_index.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/03-observability

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

jupyter lab level2/module06-property-mv-index/lab06_properties_mv_index.ipynb

4. Dependencies and services

Git
Docker Engine or Docker Desktop with Compose v2
Python 3.11 or newer
JupyterLab
The Dog Stack services described by the notebook

Module environment: Git, Docker Engine or Docker Desktop with Compose v2, Python 3.11 or newer, JupyterLab, The Dog Stack services described by the 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 ↗