dbt - Advanced Patterns
Which of the following is the correct syntax to define a sum metric named 'total_sales' in dbt YAML?
Which of the following is the correct syntax to define a sum metric named 'total_sales' in dbt YAML?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Check correct YAML keys and structure
The metric should have 'name', 'model' (using ref), 'type', and 'expression' keys.Step 2: Validate syntax correctness
metrics: - name: total_sales model: ref('sales') type: sum expression: sales_amount correctly uses 'model: ref('sales')', 'type: sum', and 'expression: sales_amount'.Final Answer:
Correct YAML syntax with ref and sum type -> Option DQuick Check:
Sum metric syntax = name, model ref, type, expression [OK]
Quick Trick: Use 'model: ref(...)' and 'type: sum' for sum metrics [OK]
Common Mistakes:
MISTAKES- Missing 'name' key or wrong indentation
- Using 'aggregation' instead of 'type'
- Not using ref() for model reference
Master "Advanced Patterns" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes