[Solved] You wrote this snapshot config:snapshots: - name: user_snapshot strategy: timestamp unique_key: user_idWhen running dbt snapshot, you get an error about missing updated_at. What is the fix? | dbt

dbt - Advanced Patterns

You wrote this snapshot config:

snapshots:
  - name: user_snapshot
    strategy: timestamp
    unique_key: user_id

When running dbt snapshot, you get an error about missing updated_at. What is the fix?

AAdd the 'updated_at' column name to the snapshot config

BRemove the unique_key from the config

CChange strategy to 'check' without check_cols

DRename the snapshot to match the source table

Step-by-Step Solution

Solution:

Step 1: Identify required fields for timestamp strategy
The timestamp strategy requires an updated_at column to detect changes.
Step 2: Fix missing updated_at error
Adding the updated_at column name to the config resolves the error. Other options do not address the missing column.
Final Answer:
Add the 'updated_at' column name to the snapshot config -> Option A
Quick Check:
Timestamp strategy needs updated_at column [OK]

Quick Trick: Timestamp snapshots require updated_at column specified [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: