dbt_project.yml configuration - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the dbt_project.yml file?

It is the main configuration file for a dbt project. It tells dbt how to build models, where to find files, and sets project-level settings.

beginner

Name two key sections you can find in dbt_project.yml.

Common sections include name (the project name) and models (settings for model folders and configurations).

intermediate

How do you specify the folder where your models live in dbt_project.yml?

Inside the models section, you set the path relative to the project root, for example: models: my_project: +materialized: view.

intermediate

What does the materialized config in dbt_project.yml control?

It controls how dbt builds models in the database, such as creating tables, views, or incremental models.

beginner

True or False: You can override model configurations for specific subfolders in dbt_project.yml.

True. You can set different configurations for subfolders by nesting them under the models section.

What is the main role of dbt_project.yml?

A Configure how dbt runs and builds models

B Store raw data files

C Write SQL queries

D Manage database users

dbt_project.yml tells dbt how to build your project and models.

Where do you define the materialization type for models in dbt_project.yml?

A Under the <code>models</code> section

B In the <code>seeds</code> section

C In the <code>snapshots</code> section

D In the <code>profiles.yml</code> file

Materialization is set inside the models section to control how models are built.

Can you set different configurations for different model folders in dbt_project.yml?

A Only by editing SQL files

B No, all models share the same config

C Yes, by nesting folder names under <code>models</code>

D Only in the database

You can customize configs per folder by nesting them under models.

Which of these is NOT a valid materialization type in dbt?

A table

B view

C incremental

D function

Valid materializations include table, view, and incremental. function is not valid.

What file do you edit to change project-level settings like the project name?

A schema.yml

B dbt_project.yml

C packages.yml

D profiles.yml

The project name and settings are in dbt_project.yml.

Explain the role of the dbt_project.yml file in a dbt project.

Think about what dbt needs to know to build your project.

Describe how you would configure different materializations for models in separate folders using dbt_project.yml.

Look at how nesting works in YAML for folder-specific settings.