[Solved] Given the following dbt command run twice with changes in model 'sales':dbt run --state ./target/run1 --select state:modified # After modifying 'sales' model dbt run --state .... | dbt

dbt - Production Deployment

Given the following dbt command run twice with changes in model 'sales':

dbt run --state ./target/run1 --select state:modified
# After modifying 'sales' model
 dbt run --state ./target/run1 --select state:modified

What will the second command do?

ARun only the 'sales' model because it was modified

BRun all models again ignoring state

CRun no models because nothing changed

DThrow an error due to incorrect state path

Step-by-Step Solution

Solution:

Step 1: Understand the first run
The first command runs all models and saves state in ./target/run1.
Step 2: Analyze the second run with modification
The second command compares current state to ./target/run1 and runs only models that changed, here 'sales'.
Final Answer:
Run only the 'sales' model because it was modified -> Option A
Quick Check:
Modified model runs only [OK]

Quick Trick: Second run runs only changed models using saved state [OK]

Common Mistakes:

MISTAKES

Master "Production Deployment" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given the following dbt command run twice with changes in model 'sales':