We have a very dynamic project environment that consists of many different disciplines. Basically, the analysts should be flexible enough to specify databases in dbt_project.yaml in which the corresponding models are created. Basically no problem, but it would be cool if the database did not already exist, but was created equivalent to the schemata.
Is there a way to realise this? I have tried it with an on-run-start and run-operation. Unfortunately, neither of these worked because target.database - i.e. the database from profiles.yaml - is used here.
Does anyone have any ideas?