Module 2: Local dbt Workflow

Building your first models

dbt Development

Project Structure

Every dbt project has a dbt_project.yml file. This is your command center.

K-12 Patterns

Tip: Always grain your student dimension by `student_id` AND `school_year`. Students change!

Hands-on: Run Your Code

Execute the following in your terminal:

$ dbt run
$ dbt test

Deliverable

Submit a Pull Request (PR) with your first staging models for `stg_students` and `stg_enrollments`.