Identify the error in this dbt model snippet:

medium📝 Debug Q14 of 15

dbt - Jinja in dbt

SELECT
  user_id,
  CASE
    WHEN age > 18 THEN 'Adult'
    WHEN age <= 18 THEN 'Minor'
    ELSE 'Unknown'
FROM users

AMissing END keyword for CASE statement

BIncorrect comparison operator in WHEN clauses

CELSE clause cannot be used in CASE

DMissing comma after user_id

Step-by-Step Solution

Solution:

Step 1: Check CASE statement syntax
CASE statements must end with END keyword to close the block.
Step 2: Verify presence of END keyword
The snippet lacks END after ELSE 'Unknown', causing syntax error.
Final Answer:
Missing END keyword for CASE statement -> Option A
Quick Check:
CASE must end with END [OK]

Quick Trick: Always close CASE with END [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More dbt Quizzes