More time coding, less time waiting: Mastering defer in dbt

This is a companion discussion topic for the original entry at More time coding, less time waiting: Mastering defer in dbt | dbt Developer Blog

A very handy feature no doubt but one caveat to add is that in some scenarios using deferral to prod can push up your costs as opposed to saving costs.

Suppose the model you are working on has upstream models with non-prod behaviour in it’s code eg. like filtering massive source data to only the last x days (to save costs in development). By deferring to the production upstream models this could lead to much more data being processed in the development environment than was intended.

In short, one should always consider the impact of deferral over just running in that mode by default.