[Solved] You wrote this dbt model in the intermediate layer:SELECT customer_id, order_date, COUNT(order_id) AS order_count FROM {{ ref('stg_orders') }}What is the error in this code? | dbt

dbt - Project Organization

You wrote this dbt model in the intermediate layer:

SELECT customer_id, order_date, COUNT(order_id) AS order_count FROM {{ ref('stg_orders') }}

What is the error in this code?

AMissing GROUP BY clause for aggregation

BIncorrect use of ref() function

CCOUNT() cannot be used in intermediate layer

DMissing WHERE clause to filter data

Step-by-Step Solution

Solution:

Step 1: Identify aggregation usage
The query uses COUNT(order_id), which is an aggregate function.
Step 2: Check for GROUP BY clause
Since non-aggregated columns customer_id and order_date are selected, a GROUP BY is required but missing.
Final Answer:
Missing GROUP BY clause for aggregation -> Option A
Quick Check:
Aggregate functions need GROUP BY for non-aggregated columns [OK]

Quick Trick: Use GROUP BY with aggregates and other columns [OK]

Common Mistakes:

MISTAKES

Master "Project Organization" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

You wrote this dbt model in the intermediate layer: