Hi, you may want to check out this discourse post about “blue/green deployment”: Performing a blue/green deploy of your dbt project on Snowflake
From the post:
What’s a blue/green deployment?
Blue-green deployment is a technique that reduces downtime and risk by running two identical production environments. Let’s take a website as an example — when you need to deploy a new version of your website, the new version is created in a separate environment. After the build is successful, traffic is routed to the new build. If anything goes wrong, you just don’t switch over the traffic
I haven’t implemented this strategy personally but it sounds like it could help you out with your usecase!