5.2 Worked Example: jaffle_shop¶
This example takes dbt Labs' jaffle_shop from a dbt project to a reviewed, published ERD. It's small (8 tables), so every step fits on screen, but nothing changes at 200 tables.
| Step | You'll | Commands |
|---|---|---|
| Step 1: Import from dbt | Generate schema files from manifest.json |
dbt docs generate, qdbd import dbt |
| Step 2: Explore the model | Read tables, docs and relationships; find join paths | qdbd serve, qdbd path |
| Step 3: Review a change | See what a branch changes before merging | qdbd diff, qdbd build --diff-base |
| Step 4: Automate in CI | Comment on PRs and publish the diagram | the GitHub Action |
The jaffle_shop diagram, live. Click orders, try the filter +orders, or open it full screen.