Naming conventions at scale in dbt - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the main purpose of naming conventions in dbt projects?

Naming conventions help keep your project organized, make it easier to understand, and allow teams to work together smoothly by using consistent names for models, tests, and sources.

beginner

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

Spaces and special characters can cause errors or confusion in SQL queries and file systems. Using underscores (_) or camelCase keeps names simple and safe to use everywhere.

intermediate

What is a common pattern for naming dbt models to show their purpose?

A common pattern is to use prefixes or suffixes like 'stg_' for staging models, 'int_' for intermediate models, and 'fct_' for fact tables. This helps quickly identify the role of each model.

intermediate

How do naming conventions help when your dbt project grows larger?

They make it easier to find and understand models, avoid name clashes, and support automation tools that rely on predictable names. This saves time and reduces mistakes.

beginner

What should you consider when naming sources in dbt?

Use clear, descriptive names that match the original data source names or business terms. This helps everyone know where data comes from and keeps documentation clear.

Which of the following is a good naming convention for a staging model in dbt?

A customers staging

B Customers Staging

C stg_customers

D stg-customers!

Using 'stg_customers' is clear, consistent, and avoids spaces or special characters.

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

A To confuse new team members

B To make the project look colorful

C To make SQL queries longer

D To help team members understand and find models easily

Consistent naming helps everyone understand the project and find what they need quickly.

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

A _

B -

C Space

D !

Underscores (_) are safe and commonly used to separate words in names.

What prefix might you use for a fact table model in dbt?

A dim_

B fct_

C stg_

D tmp_

'fct_' is commonly used to indicate fact tables in naming conventions.

When naming sources in dbt, you should:

A Match names to original data sources or business terms

B Use random abbreviations

C Use very long names with spaces

D Use special characters to stand out

Clear, descriptive names matching original sources help with understanding and documentation.

Explain why consistent naming conventions are important when your dbt project grows.

Think about how many people and models are involved in a big project.

Describe a simple naming pattern you could use for different types of dbt models.

Consider how to quickly tell what a model does just by its name.