I’m using dbt cloud, trying out the single developer version. My DW is BQ.
I wish to add a deployment environment which would be a different project and dataset to that of my development environment.
I can work around this using a macro set the target name etc. However I want the execution context (billing and slots usage) to be against the target project.
In dbt CLI this seems possible by setting this in the profiles.yml
Is there any way to do this with dbt Cloud? Why isn’t the profiles.yml available?
I see demo videos of people adding an environment and setting the deployment credentials. However, I only get the option to set a dataset: