dbt - Performance Optimization
In dbt, which configuration parameter is used to define clustering keys for a Snowflake model?
In dbt, which configuration parameter is used to define clustering keys for a Snowflake model?
easy🧠 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify clustering parameter
In Snowflake, clustering keys are specified using thecluster_byconfig in dbt.Step 2: Differentiate from other configs
partition_byis used in BigQuery,sort_keysis for Redshift, andunique_keyis for incremental models.Final Answer:
cluster_by -> Option CQuick Check:
Clustering keys in Snowflake usecluster_by[OK]
Quick Trick: Use cluster_by for Snowflake clustering keys [OK]
Common Mistakes:
MISTAKES- Confusing partition_by with cluster_by
- Using sort_keys in Snowflake models
- Setting unique_key as clustering key
Master "Performance Optimization" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes