Walk A Grain Change Safely
Handle a requested grain change without silently breaking downstream models.
Incident A team is changing a model from one row per order to one row per order item while finance waits for a number. The path you choose changes whether dbt can explain the result. Contain, declare, prove Good dbt moves narrow blast radius, declare dependencies, and prove assumptions with tests. Shortcut Patch the final SQL Traceable change Every decision should improve lineage or evidence. Step 1 Product asks to add SKU-level margin to fct_orders. What is the first decision? Step 2 Three dashboards and one reverse-ETL job depend on fct_orders. What design reduces blast radius? Now you try A…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in