[Solved] What is wrong with this dbt model SQL snippet?SELECT id, CASE WHEN score >= 90 THEN 'A' WHEN score >= 80 THEN 'B' WHEN score >= 70 THEN 'C' ELSE 'F' FROM grades | dbt

dbt - Jinja in dbt

What is wrong with this dbt model SQL snippet?

SELECT
  id,
  CASE WHEN score >= 90 THEN 'A'
       WHEN score >= 80 THEN 'B'
       WHEN score >= 70 THEN 'C'
       ELSE 'F'
FROM grades

AMissing END keyword for CASE statement

BIncorrect ELSE syntax

CWrong table name

DNo error

Step-by-Step Solution

Solution:

Step 1: Check CASE statement completeness
The CASE statement must end with END keyword, which is missing here.
Step 2: Confirm other syntax parts
ELSE syntax is correct, table name is valid, so missing END is the error.
Final Answer:
Missing END keyword for CASE statement -> Option A
Quick Check:
CASE must end with END keyword [OK]

Quick Trick: Always close CASE with END keyword [OK]

Common Mistakes:

MISTAKES

Master "Jinja in dbt" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

What is wrong with this dbt model SQL snippet?