[Solved] A dbt model runs slowly and costs more than expected. The SQL is:SELECT customer_id, order_id FROM ordersWhat optimization can reduce costs? | dbt

dbt - Performance Optimization

A dbt model runs slowly and costs more than expected. The SQL is:

SELECT customer_id, order_id FROM orders

What optimization can reduce costs?

ARemove GROUP BY clause

BAdd more columns to SELECT *

CAdd a WHERE clause to filter recent orders

DUse SELECT * instead of specific columns

Step-by-Step Solution

Solution:

Step 1: Identify lack of filtering causing large data scans
Without filtering, the query scans all orders, increasing cost and runtime.
Step 2: Add a WHERE clause to limit data scanned
Filtering recent orders reduces data scanned, lowering cost and improving speed.
Final Answer:
Add a WHERE clause to filter recent orders -> Option C
Quick Check:
Filter data to reduce cost = C [OK]

Quick Trick: Filter data to speed queries and save cost [OK]

Common Mistakes:

MISTAKES

Master "Performance Optimization" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

A dbt model runs slowly and costs more than expected. The SQL is: