dbt project structure - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the main purpose of the models directory in a dbt project?

The models directory holds SQL files that define transformations and create tables or views in your data warehouse.

beginner

What file in a dbt project defines project-level configurations like name and version?

The dbt_project.yml file defines project-level settings such as the project name, version, and model configurations.

intermediate

What is the role of the macros folder in a dbt project?

The macros folder contains reusable SQL snippets or functions that can be called inside models to avoid repetition.

intermediate

Why do dbt projects include a tests directory?

The tests directory stores custom tests to check data quality and ensure models produce correct results.

beginner

What is the purpose of the seeds directory in a dbt project?

The seeds directory holds CSV files that dbt can load as tables into the data warehouse for static or reference data.

Which file in a dbt project controls the project name and version?

A dbt_project.yml

B profiles.yml

C packages.yml

D models.sql

The dbt_project.yml file contains project-level settings including the project name and version.

Where do you put SQL files that define data transformations in dbt?

A models directory

B macros directory

C tests directory

D seeds directory

The models directory contains SQL files that define how data is transformed and stored.

What is stored in the seeds directory of a dbt project?

A Project configuration

B SQL macros

C Test scripts

D CSV files for static data

Seeds are CSV files loaded as tables for static or reference data.

Which folder contains reusable SQL functions in dbt?

A models

B macros

C tests

D seeds

Macros hold reusable SQL snippets or functions.

Why do dbt projects have a tests directory?

A To store CSV files

B To store project settings

C To store data quality checks

D To store SQL macros

Tests help ensure data quality by checking model outputs.

Describe the main folders in a dbt project and their purposes.

Think about where you put SQL code, reusable parts, tests, static data, and settings.

Explain how the dbt_project.yml file fits into the dbt project structure.

It is the main settings file for the whole project.