We want the target schemas names to be same across environment like Dev, QA and Prod. What should we do to achieve this configuration?

Hi Team,

I have read the official custom schema documentation in great detail, but we want to have specific schemas for each data source across i.e. Salesforce, SAP etc. across multiple environment i.e. Dev, QA and Prod in our database as described below :

I also understand that dbt doesn’t recommend such a scenario, due to multiple users updating the same model in a schema. So I have 2 questions :slight_smile:

  1. How to config for such a scenario? What changes should be made to default code of generate_schema_name macro ?

  2. What are the potential repercussion we will have face when we go ahead with this approach?