Quick Reference: Materialization Calls Under Pressure
Recall the fastest practical heuristics for choosing dbt materializations.
When a shared transformation is getting expensive, how do view and table differ? View vs table Choose based on graph-wide recomputation cost, not on a blanket preference for lower storage. Common objection “The model is slow, so let's just make it incremental.” You are in a review and someone is optimizing runtime before checking whether old rows ever need correction. Your line “Incremental is only strong if we can name the affected row window and trust the merge semantics. Otherwise we are making bad data faster.” Treating incrementality as a default speed lever instead of a correctness strategy. It reframes…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in