Model naming conventions in dbt - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the main purpose of using model naming conventions in dbt?

Model naming conventions help keep your project organized, make models easy to find, and improve collaboration by using clear and consistent names.

beginner

In dbt, what does a model name usually represent?

A model name usually represents a single table or view in your data warehouse, often describing the data it contains or the transformation it performs.

beginner

Why should you avoid using spaces or special characters in dbt model names?

Spaces and special characters can cause errors or confusion in SQL queries and file systems, so using underscores or lowercase letters keeps names safe and consistent.

intermediate

What is a common pattern for naming dbt models that represent raw data sources?

A common pattern is to prefix raw data source models with 'stg_' (short for staging), like 'stg_customers', to show they are initial cleaned versions of source data.

intermediate

How can consistent model naming conventions improve teamwork in dbt projects?

Consistent names make it easier for team members to understand what each model does, find models quickly, and avoid mistakes when writing or reviewing code.

Which of the following is a good dbt model name for a cleaned customer data table?

A clean customers

B Clean Customers

C clean-customers

D clean_customers

Model names should use underscores and lowercase letters without spaces or special characters.

What prefix is commonly used for staging models in dbt?

A stg_

B raw_

C int_

D final_

The prefix 'stg_' is commonly used to indicate staging models that clean raw data.

Why is it important to have consistent naming conventions in dbt models?

A To improve organization and collaboration

B To confuse team members

C To make models harder to find

D To increase file size

Consistent naming helps organize models and makes teamwork easier.

Which character is recommended to separate words in dbt model names?

A Space

B -

C _

D .

Underscores (_) are recommended to separate words in model names.

What does a dbt model name usually describe?

A The color of the data

B The data or transformation it contains

C The size of the database

D The user who created it

Model names describe the data or transformation they represent.

Explain why using consistent model naming conventions is important in dbt projects.

Think about how clear names help you and your team work better.

Describe a good naming pattern for staging models in dbt and why it helps.

Focus on how naming shows the model's role.