[Solved] A dbt model for Snowflake uses this config:config( materialized='incremental', cluster_by=['region'] )But queries on the model are slow. What could be wrong? | dbt

dbt - Performance Optimization

A dbt model for Snowflake uses this config:

config(
  materialized='incremental',
  cluster_by=['region']
)

But queries on the model are slow. What could be wrong?

AClustering keys should include multiple columns for better performance

BThe clustering keys are not maintained after incremental loads unless manually reclustered

CIncremental models do not support clustering in Snowflake

DThe cluster_by config must be inside the SQL select statement

Step-by-Step Solution

Solution:

Step 1: Understand clustering behavior with incremental models
Snowflake clustering keys are not automatically maintained after incremental inserts; reclustering is needed.
Step 2: Identify why queries remain slow
Without reclustering, data is not physically organized, causing slow queries despite cluster_by config.
Final Answer:
The clustering keys are not maintained after incremental loads unless manually reclustered -> Option B
Quick Check:
Incremental + clustering needs manual recluster [OK]

Quick Trick: Recluster after incremental loads to maintain clustering [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 for Snowflake uses this config: