[Solved] Given this dbt model SQL snippet, what will be the output columns?SELECT customer_id, SUM(amount) AS total_amount FROM {{ ref('orders') }} GROUP BY customer_id | dbt

dbt - Governance and Collaboration

Given this dbt model SQL snippet, what will be the output columns?

SELECT customer_id, SUM(amount) AS total_amount FROM {{ ref('orders') }} GROUP BY customer_id

Acustomer_id only

Bcustomer_id, total_amount

Ccustomer_id, sum_amount

Dcustomer_id, amount

Step-by-Step Solution

Solution:

Step 1: Analyze SQL aggregation
The query sums 'amount' grouped by 'customer_id' and aliases it as 'total_amount'.
Step 2: Identify output columns
Output columns are 'customer_id' and 'total_amount' as per SELECT clause.
Final Answer:
customer_id, total_amount -> Option B
Quick Check:
Output columns = customer_id, total_amount [OK]

Quick Trick: Alias aggregated columns explicitly for clarity [OK]

Common Mistakes:

MISTAKES

Master "Governance and Collaboration" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this dbt model SQL snippet, what will be the output columns?