[Solved] Given this metric definition in dbt YAML:metrics: - name: total_revenue model: ref('orders') label: 'Total Revenue' type: sum sql:... | dbt

dbt - Advanced Patterns

Given this metric definition in dbt YAML:

metrics:
  - name: total_revenue
    model: ref('orders')
    label: 'Total Revenue'
    type: sum
    sql: amount

What will be the output of querying this metric if the 'orders' table has amounts: [100, 200, 300]?

A600

B3

C100

D900

Step-by-Step Solution

Solution:

Step 1: Understand metric type and SQL field
The metric type is 'sum' on the 'amount' field, so it adds all amounts.
Step 2: Calculate sum of amounts
Sum of [100, 200, 300] = 100 + 200 + 300 = 600.
Final Answer:
600 -> Option A
Quick Check:
Sum amounts = 600 [OK]

Quick Trick: Sum metric adds all values in the specified column [OK]

Common Mistakes:

MISTAKES

Master "Advanced Patterns" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this metric definition in dbt YAML: