[Solved] Identify the error in this dbt model SQL snippet:SELECT product_id, SUM(quantity) AS total_quantity FROM orders WHERE order_date GROUP BY product_id | dbt

dbt - Governance and Collaboration

Identify the error in this dbt model SQL snippet:

SELECT product_id, SUM(quantity) AS total_quantity FROM orders WHERE order_date GROUP BY product_id

Aproduct_id should be aliased

BMissing condition after WHERE clause

CSUM() cannot be used with GROUP BY

DGROUP BY should come before WHERE

Step-by-Step Solution

Solution:

Step 1: Check WHERE clause syntax
WHERE clause requires a condition; here it is incomplete.
Step 2: Validate SQL order
GROUP BY correctly follows WHERE; SUM() is valid with GROUP BY.
Final Answer:
Missing condition after WHERE clause -> Option B
Quick Check:
WHERE needs condition [OK]

Quick Trick: Always provide a condition after WHERE [OK]

Common Mistakes:

MISTAKES

Master "Governance and Collaboration" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Identify the error in this dbt model SQL snippet: