[Solved] You wrote this dbt model config:config( materialized='table', partition_by={'field': 'order_date', 'data_type': 'timestamp'}, clustering='customer_id' )Why does this cause an error? | dbt

dbt - Performance Optimization

You wrote this dbt model config:

config(
  materialized='table',
  partition_by={'field': 'order_date', 'data_type': 'timestamp'},
  clustering='customer_id'
)

Why does this cause an error?

AClustering should be a list, not a string

BPartitioning data_type 'timestamp' is invalid

CMaterialized type 'table' does not support clustering

DField 'order_date' must be lowercase

Step-by-Step Solution

Solution:

Step 1: Check clustering syntax
Clustering expects a list of columns, but a string was given.
Step 2: Validate other config parts
Partitioning with 'timestamp' is valid, 'table' supports clustering, and field case is not an error.
Final Answer:
Clustering should be a list, not a string -> Option A
Quick Check:
Clustering requires list syntax [OK]

Quick Trick: Always use a list for clustering columns [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: