[Solved] Given the following dbt model code in the intermediate layer:SELECT customer_id, COUNT(order_id) AS total_orders FROM {{ ref('stg_orders') }} GROUP BY customer_idWhat will be the output columns of... | dbt

dbt - Project Organization

Given the following dbt model code in the intermediate layer:

SELECT
  customer_id,
  COUNT(order_id) AS total_orders
FROM {{ ref('stg_orders') }}
GROUP BY customer_id

What will be the output columns of this model?

Acustomer_id, total_orders

Border_id, total_orders

Ccustomer_id, order_id

Dcustomer_id only

Step-by-Step Solution

Solution:

Step 1: Analyze SELECT statement
The query selects customer_id and counts order_id as total_orders.
Step 2: Understand GROUP BY effect
Grouping by customer_id means output will have one row per customer with total orders counted.
Final Answer:
customer_id, total_orders -> Option A
Quick Check:
Output columns = customer_id and total_orders [OK]

Quick Trick: GROUP BY columns + aggregated columns appear in output [OK]

Common Mistakes:

MISTAKES

Master "Project Organization" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given the following dbt model code in the intermediate layer: