In case we ignore the custom schema recommendation by dbt for Dev and QA environment, and have them in same schema as Prod. What are the disadvantage or possible issues with this approach in a multi-user environment?

sushant.jain3 August 3, 2023, 9:35am 1

Currently we are using the following macro (not recommended by dbt):

Topic		Replies	Views
We want the target schemas names to be same across environment like Dev, QA and Prod. What should we do to achieve this configuration? In-Depth Discussions custom-schema	0	1200	August 3, 2023
Custom Versions of generate_schema_name Show and Tell jinja , environments	0	4910	September 8, 2020
Custom schema names, I need the behavior warned against in the docs. How do I do it? Help jinja , best-practice , dbt-core	0	580	March 26, 2024
How to set DB to support multiple projects with an organisation? Archive	3	4711	April 27, 2021
[Obsolete] The exact grant statements we use in a dbt project Archive	4	39700	July 10, 2019