Courses/Data/dbt From Zero, Part 2: Project Anatomy & Your First Models
Shadab Barmare

dbt From Zero, Part 2: Project Anatomy & Your First Models

Learn how a dbt project is organised and build your first models on CocoaCo’s chocolate-shop data. You build views with dbt run, check them with dbt show and fix failing models by reading their errors. Part 2 of the dbt From Zero series.

1 student enrolled
Free lesson·2h·Data

What you'll learn

What each folder and setting in a dbt project is for

What a model is, and the rules every model follows

Building models as views in your own schema with dbt run

Checking results with dbt show and reading the SQL dbt sends to the database

Building one model or one folder with --select

Reading dbt and DuckDB error messages to fix a failing model

Syllabus

Lab 1 — Project anatomy & your first model
  • •Concept: What’s inside a dbt project?
  • •Guided walkthrough: build your first model
  • •Lab 1 Challenge: CocoaCo’s first recipes
  • •Lab 1 Quiz
Feedback & Certificate
  • •Course Feedback (Required for Certificate)

What's included

Certificate of completion

Complete every lesson and the short feedback form to download your CtrlSkill certificate

Course material

1 lab: 2 lessons, 1 hands-on challenge, 1 quiz (about 2 hours)

Prerequisites

  • •Completed Part 1, "dbt From Zero: Hands-On Labs with DuckDB", with dbt debug ending in "All checks passed!"
  • •The cocoaco_dbt project and the cocoaco.duckdb file from Part 1 on your computer
  • •Reading a basic SQL query with GROUP BY. HAVING is introduced in this lab.
  • •About 2 hours

Who is this for?

  • •Data analysts who write SQL and want to build reliable data pipelines
  • •Students and career changers moving into data analytics or analytics engineering
  • •BI developers who want to understand how the data behind their dashboards is built