dbt - Advanced Patterns
Given this metric definition:
metrics:
- name: total_orders
model: ref('orders')
type: count
expression: order_id
What will be the output of querying this metric if the 'orders' model has 150 rows?
Given this metric definition: metrics: - name: total_orders model: ref('orders') type: count expression: order_id What will be the output of querying this metric if the 'orders' model has 150 rows?
medium📝 Predict Output Q4 of 15
Step-by-Step Solution
Solution:
Step 1: Understand count metric behavior
A count metric counts the number of rows based on the expression column.Step 2: Apply to given data
Since 'orders' has 150 rows, counting 'order_id' returns 150.Final Answer:
150 -> Option CQuick Check:
Count metric output = number of rows [OK]
Quick Trick: Count metrics return row counts, not sums [OK]
Common Mistakes:
MISTAKES- Thinking count sums values instead of counting rows
- Assuming expression is optional for count
- Expecting zero output without filtering
Master "Advanced Patterns" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes