Sorry I totally missed this message! Thanks for the info.
I think we’ll be trying to setup a dev environment somewhere down the line, so I’ll probably suggest a similar approach to what you have.
When you merge into main, do you basically have a way of passing in a prod variable into the pipelines/deployments, which ensure the prod pipelines are looking at prod schemas when loading data?