Naming conventions at scale in dbt - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Why use consistent naming conventions in dbt projects?

In dbt projects, why is it important to use consistent naming conventions for models, sources, and tests?

A It prevents dbt from running models in parallel, ensuring sequential execution.

B It allows dbt to automatically generate documentation without any manual input.

C It helps in organizing the project and makes it easier to understand and maintain over time.

D It reduces the size of the compiled SQL files, improving performance.

💡 Hint

Think about how naming helps humans and teams working together.

Consistent naming conventions improve readability and maintainability, making it easier for teams to collaborate and understand the project structure.

❓ data_output

intermediate

Identify the correct model name from naming conventions

Given the naming convention stg_ prefix for staging models and int_ for intermediate models, which of the following is a correctly named intermediate model?

A stg_customer_orders

B raw_customer_orders

C customer_orders_stg

D int_customer_orders

💡 Hint

Look for the prefix that matches intermediate models.

Intermediate models use the int_ prefix, so int_customer_orders is correct.

❓ Predict Output

advanced

Output of dbt model naming with variables

Consider this dbt model naming snippet using Jinja variables:

{% set prefix = 'stg' %}
select * from {{ prefix }}_sales_data

What is the resulting table name when compiled?

A stg_sales_data

B {{ prefix }}_sales_data

C sales_data

D stg_sales_data_data

💡 Hint

Jinja variables are replaced during compilation.

The variable prefix is set to stg, so the compiled name is stg_sales_data.

🔧 Debug

advanced

Identify the naming error causing dbt model failure

Which of the following model names will cause a dbt compilation error due to invalid naming conventions?

A int_customer_data

B customer-data

C stg_customer_data

D raw_customer_data

💡 Hint

Check for characters not allowed in dbt model names.

Model names cannot contain hyphens; customer-data is invalid and causes compilation errors.

🚀 Application

expert

Determine the number of models following naming conventions

You have a dbt project with the following models:

• stg_orders
• int_orders_summary
• raw_orders
• orders_final
• stg_customers
• int_customers_summary

According to the naming convention where stg_ is staging, int_ is intermediate, and raw_ is raw data, how many models follow the naming convention correctly?

A 5

B 4

C 3

D 6

💡 Hint

Count models with correct prefixes only.

Models with prefixes stg_, int_, and raw_ follow conventions. orders_final does not have a prefix, so 5 models follow conventions.