I am running a model_a that is dependent on another model_b. In my select command model_b is not present and model_b is also not in my development schema (I did a drop schema to reset)
Before defer:
select * from “database_dev”.“my_user_schema”.“model_b”
After defer:
select * from “database_dev”.“data_analytics”.“model_b”
As you can see, deferring changed the schema from “my_user” to “data_analytics” which I expect but its still using database_dev instead of database_prod. The issue is my database_dev is not up to date with prod so it makes deferring not useful. How can I configure it to point to the prod DB?