[Solved] Consider this dbt model in the intermediate layer:SELECT product_id, AVG(price) AS avg_price FROM {{ ref('stg_products') }} GROUP BY product_idWhat columns will this model produce? | dbt

dbt - Project Organization

Consider this dbt model in the intermediate layer:

SELECT product_id, AVG(price) AS avg_price FROM {{ ref('stg_products') }} GROUP BY product_id

What columns will this model produce?

Aproduct_id, AVG(price)

Bproduct_id, price

Cproduct_id, avg_price

Dproduct_id only

Step-by-Step Solution

Solution:

Step 1: Identify selected columns
The query selects product_id and calculates AVG(price) as avg_price.
Step 2: Understand aliasing
The aggregate function AVG(price) is aliased as avg_price, so the output column will be named avg_price.
Final Answer:
product_id, avg_price -> Option C
Quick Check:
Check column aliases in SELECT clause [OK]

Quick Trick: Alias aggregate functions to name output columns [OK]

Common Mistakes:

MISTAKES

Master "Project Organization" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Consider this dbt model in the intermediate layer: