[Solved] You wrote this dbt model config for Redshift:config( materialized='table', sort_keys=['date', 'user_id'] )But the model fails to build. What is the likely cause? | dbt

dbt - Performance Optimization

You wrote this dbt model config for Redshift:

config(
  materialized='table',
  sort_keys=['date', 'user_id']
)

But the model fails to build. What is the likely cause?

Asort_keys should be specified inside partition_by

Bsort_keys should be a dictionary, not a list

CThe materialized type must be incremental to use sort_keys

Dsort_keys is not a valid config option in dbt for Redshift

Step-by-Step Solution

Solution:

Step 1: Check valid config options for Redshift in dbt
Redshift uses dist and sort (list of columns), not sort_keys.
Step 2: Identify the error
Using sort_keys causes a syntax error because it is not recognized.
Final Answer:
sort_keys is not a valid config option in dbt for Redshift -> Option D
Quick Check:
Invalid config option causes build failure [OK]

Quick Trick: Use sort=['date', 'user_id'] for Redshift sort keys [OK]

Common Mistakes:

MISTAKES

Master "Performance Optimization" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

You wrote this dbt model config for Redshift: