[Solved] You wrote this snapshot config:snapshots: - name: order_snapshot strategy: timestamp updated_at: updated_at_columnBut dbt throws an error. What is the likely cause? | dbt

dbt - Advanced Patterns

You wrote this snapshot config:

snapshots:
  - name: order_snapshot
    strategy: timestamp
    updated_at: updated_at_column

But dbt throws an error. What is the likely cause?

AThe 'updated_at' key should be inside 'config' block

BThe 'strategy' value 'timestamp' is invalid

CThe 'updated_at' key is missing quotes

DThe 'updated_at' key should be 'updated_at_column'

Step-by-Step Solution

Solution:

Step 1: Check snapshot config keys for timestamp strategy
For 'timestamp' strategy, the correct key is updated_at_column, not updated_at.
Step 2: Identify the error cause
Using updated_at causes dbt to error because it expects updated_at_column.
Final Answer:
The 'updated_at' key should be 'updated_at_column' -> Option D
Quick Check:
Timestamp strategy key = updated_at_column [OK]

Quick Trick: Use 'updated_at_column' key for timestamp strategy [OK]

Common Mistakes:

MISTAKES

Master "Advanced Patterns" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

You wrote this snapshot config: