One model per source table rule in dbt - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the 'One model per source table' rule mean in dbt?

It means creating one dbt model for each source table to keep transformations simple and organized.

beginner

Why is it helpful to have one model per source table?

It makes debugging easier, improves clarity, and helps track data lineage clearly.

intermediate

How does the 'One model per source table' rule affect complex transformations?

Complex transformations are built by layering simple models, each based on one source table, making the process easier to manage.

beginner

What is a common mistake when not following the 'One model per source table' rule?

Combining multiple source tables in one model can make the code hard to read and maintain.

intermediate

How does this rule help with testing in dbt?

Testing is simpler because each model corresponds to one source table, so tests can focus on one data set at a time.

What is the main benefit of having one model per source table in dbt?

A Reduces the number of models needed

B Simplifies debugging and improves clarity

C Combines all data into one place

D Avoids writing SQL code

Having one model per source table keeps transformations simple and makes debugging easier.

What happens if you combine multiple source tables in one dbt model?

A The code can become complex and hard to read

B It automatically improves performance

C The model becomes easier to maintain

D It reduces the need for testing

Combining multiple source tables in one model can make the code complex and harder to maintain.

How does the 'One model per source table' rule help with data lineage?

A It hides the source tables

B It makes data lineage unclear

C It clearly shows how data flows from source to model

D It removes the need for documentation

Each model corresponds to one source table, making it easy to track data lineage.

Which of these is a good practice when following the 'One model per source table' rule?

A Create one model that joins all source tables

B Write all transformations in one SQL file

C Avoid creating models for source tables

D Create separate models for each source table

Creating separate models for each source table keeps the project organized and easier to manage.

How does this rule affect testing in dbt?

A Testing can focus on one source table at a time

B Testing becomes more complicated

C Testing is not needed

D Testing must cover all tables together

Testing is simpler because each model corresponds to one source table, allowing focused tests.

Explain the 'One model per source table' rule and why it is important in dbt projects.

Think about how this rule helps keep your project clean and easy to understand.

Describe how following the 'One model per source table' rule impacts testing and maintenance.

Consider how simple models help you find and fix problems faster.