Using Dataflows & Deployment Pipelines across Dev/Test/Prod

Hello,

I'm trying to set up a deployment pipeline for our reports, and have a workspace set up for Dev, Test, and Prod content (1 workspace for each stage). My understanding is that we can use deployment pipelines to keep Dev & Test workspaces connected to a Dev database, and then have our Prod workspace connected to our Prod database. Now when I publish from Test to Prod within the Deployment Pipeline, how do I set this up so that the content then connects to Prod instead of Test?

Normally I would try to use the Data Source rules in the deployment pipeline, but we're using Dataflows to bring in data from Snowflake. So therefore I don't have the option to modify the data source when publishing to Production. Perhaps I'm doing something wrong, so I'm open to any and all suggestions. This is a new deployment, so we have a relatively blank slate to work from.