I have a dbt project and profile, let’s say its name is abc. I’ve run the models in this project before. I recently changed the profile target schema to a new location for a data refresh. However, when I looked at the compiled codes, I noticed that dbt was using mixed target schema
- sometimes using the target schema from previous,
- sometimes using the new target schema.
I have to change the profile name to a different one, i.e. abc2 to stop confusing dbt. However, this issue has never happened before. I’m not sure why. It made me wonder if it’s related to the upgrade to 1.2.1. Can someone help me? Thank you!