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.