[Solved] Given this dbt model snippet:SELECT user_id, CASE WHEN age >= 18 THEN 'adult' ELSE 'minor' END AS age_group FROM usersWhat will be the value of age_group for a user with age 16? | dbt

dbt - Jinja in dbt

Given this dbt model snippet:

SELECT
  user_id,
  CASE WHEN age >= 18 THEN 'adult' ELSE 'minor' END AS age_group
FROM users

What will be the value of age_group for a user with age 16?

A'minor'

B'adult'

CNULL

DError

Step-by-Step Solution

Solution:

Step 1: Analyze the CASE condition for age 16
The condition checks if age >= 18; 16 is less than 18, so condition is false.
Step 2: Determine the ELSE result
Since condition is false, the ELSE branch 'minor' is returned.
Final Answer:
'minor' -> Option A
Quick Check:
Age 16 < 18 -> age_group = 'minor' [OK]

Quick Trick: If condition false, ELSE value is returned [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this dbt model snippet: