I have a database where for each customer there is one specific schema. All the schemas share the same layout.
customer_1.orders
customer_2.orders
.
.
.
customer_n.orders
I am trying to have a small etl process using dbt to create the following. I want a transformed orders_fact table in each of these schemas.
customer_1.orders_fact
customer_2.orders_fact
.
.
.
customer_n.orders_fact
On top each schema has a unique user/password combination to access the data (e.g. schema customer_1 has username: user_1, password: random_password).
How would I set this up in dbt. I am currently struggling with the unique name constraint of a model and how to set up the config in a way that for each schema there are specific credentials.