Source from Staging, Output to Dev

Is there anyway to build a model (dbt run) and have ref source from one schema for model relationships, but have the run output to a different schema? i.e. avoid having to build upstream models by just running against a staging schema that already has all the models built, but output the new model (and/or downstream models) to a dev schema.

@Proton look into deferral - this should be exactly what you’re after! Defer | dbt Developer Hub

For an example of this in the real world (in a CI context instead of a development context, but the behaviours are the same), check out How we sped up our CI runs by 10x using Slim CI

Yes, this is exactly what I was after. Thanks!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.