[Solved] Given this snapshot config snippet:snapshots: - name: customer_snapshot strategy: check check_cols: ['email', 'status']What happens when the email or status changes in the source data? | dbt

dbt - Advanced Patterns

Given this snapshot config snippet:

snapshots:
  - name: customer_snapshot
    strategy: check
    check_cols: ['email', 'status']

What happens when the email or status changes in the source data?

AThe snapshot process ignores changes in these columns

BThe existing record is overwritten without history

CA new record version is created in the snapshot table

DAn error occurs because check_cols is invalid

Step-by-Step Solution

Solution:

Step 1: Understand 'check' strategy with check_cols
The 'check' strategy tracks changes in specified columns and creates new versions when they change.
Step 2: Apply to given columns
If 'email' or 'status' changes, dbt adds a new record version to keep history.
Final Answer:
A new record version is created in the snapshot table -> Option C
Quick Check:
Check strategy tracks column changes = new version [OK]

Quick Trick: Check strategy creates new versions on column changes [OK]

Common Mistakes:

MISTAKES

Master "Advanced Patterns" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this snapshot config snippet: