dbt - Performance Optimization
Why does clustering in Snowflake require manual reclustering after incremental loads?
Why does clustering in Snowflake require manual reclustering after incremental loads?
hard🧠 Conceptual Q10 of 15
Step-by-Step Solution
Solution:
Step 1: Understand Snowflake clustering behavior
Snowflake clustering physically organizes data but does not auto-maintain it after inserts or updates.Step 2: Explain need for manual reclustering
Without manual reclustering, data becomes less organized, causing slower queries.Final Answer:
Because Snowflake does not automatically reorganize data after inserts, so clustering can degrade -> Option AQuick Check:
Manual reclustering needed due to no auto-maintenance [OK]
Quick Trick: Snowflake clustering needs manual recluster after data changes [OK]
Common Mistakes:
MISTAKES- Thinking clustering keys apply only at creation
- Assuming incremental disables clustering
- Confusing clustering with partitioning
Master "Performance Optimization" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes