Dynamic Connection Switching Based on Development Mode

[Abhishekpv1995]

We currently have two database environments: prod and preprod. At the moment, our Looker instance connects only to the prod environment. However, we would like to enable developers to automatically connect to the preprod environment when they are in Development Mode, so they can safely explore and test without impacting production data. We would like to change the connection parameter in model file based on Production or Development mode

Could you please point out to me if it possible to achieve? or suggest any other alternatives to achieve this ?