[Solved] Consider this snapshot config:snapshots: - name: product_snapshot strategy: check unique_key: product_id check_cols: ['price', 'description']What triggers a new snapshot record? | dbt

dbt - Advanced Patterns

Consider this snapshot config:

snapshots:
  - name: product_snapshot
    strategy: check
    unique_key: product_id
    check_cols: ['price', 'description']

What triggers a new snapshot record?

ASnapshot updates only on timestamp changes

BAny change in 'price' or 'description' columns

CAll columns must change to trigger snapshot

DOnly changes in 'product_id'

Step-by-Step Solution

Solution:

Step 1: Understand 'check' strategy in snapshots
The 'check' strategy creates a new record if any column in check_cols changes.
Step 2: Evaluate options
Any change in 'price' or 'description' columns matches this behavior. Only changes in 'product_id' is wrong because unique_key identifies records but does not trigger snapshots. All columns must change to trigger snapshot is false; not all columns must change. Snapshot updates only on timestamp changes applies to timestamp strategy, not check.
Final Answer:
Any change in 'price' or 'description' columns -> Option B
Quick Check:
Check strategy triggers on specified column changes [OK]

Quick Trick: Check strategy snapshots on specified column changes [OK]

Common Mistakes:

MISTAKES

Master "Advanced Patterns" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Consider this snapshot config: