dbt - Performance Optimization
Which of the following is the correct syntax to add clustering in a dbt model's
config block?Which of the following is the correct syntax to add clustering in a dbt model's config block?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Recall dbt clustering syntax
In dbt, clustering is set usingcluster_by = ['column_name']inside the model config.Step 2: Check other options
Options likeclustering,cluster, orclustersare incorrect keywords.Final Answer:
cluster_by = ['column_name'] -> Option AQuick Check:
Correct keyword is cluster_by [OK]
Quick Trick: Use 'cluster_by' keyword exactly in config [OK]
Common Mistakes:
MISTAKES- Using clustering instead of cluster_by
- Misspelling cluster_by keyword
- Using plural clusters instead of cluster_by
Master "Performance Optimization" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes