[Solved] Examine this dbt model SQL snippet:SELECT user_id, CASE WHEN age > 18 THEN 'adult' ELSE 'minor' END AS age_group FROM usersWhat is the error in this snippet? | dbt

dbt - Jinja in dbt

Examine this dbt model SQL snippet:

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

What is the error in this snippet?

AMissing END keyword to close CASE statement.

BThere is no error; the syntax is correct.

CIncorrect use of ELSE without a preceding WHEN.

DCASE should be followed by a column name directly.

Step-by-Step Solution

Solution:

Step 1: Review CASE syntax
The snippet uses CASE with WHEN and ELSE clauses, properly closed with END.
Step 2: Check for syntax errors
All keywords are correctly placed and the CASE statement is properly terminated.
Final Answer:
No error; syntax is correct. -> Option B
Quick Check:
CASE with WHEN, ELSE, and END is valid [OK]

Quick Trick: CASE needs WHEN, ELSE, and END keywords [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Examine this dbt model SQL snippet: