If you have a dbt model named orders that selects all columns from the source table sales.orders, what will happen if you add a filter where status = 'completed' in the model?
medium📝 Predict Output Q5 of 15
dbt - Project Organization
If you have a dbt model named orders that selects all columns from the source table sales.orders, what will happen if you add a filter where status = 'completed' in the model?
AThe model will return only completed orders from the source table.
BThe model will fail because filters are not allowed on source tables.
CThe model will return all orders ignoring the filter.
DThe model will create a new source table with filtered data.
Step-by-Step Solution
Solution:
Step 1: Understand filter effect in dbt model
Adding a where clause filters rows returned by the model.
Step 2: Evaluate options
The model will return only completed orders from the source table. correctly states the model returns only filtered rows; others are incorrect.
Final Answer:
The model will return only completed orders from the source table. -> Option A
Quick Check:
Filters in models limit rows returned [OK]
Quick Trick:Filters in models limit rows returned from source [OK]
Common Mistakes:
MISTAKES
Thinking filters cause errors
Assuming filters are ignored
Believing models create new source tables
Master "Project Organization" in dbt
9 interactive learning modes - each teaches the same concept differently
