Parameter to switch between 3 different Redshift connections (TEST, ACC, PROD)

[cmfaarvang]

Hi,

I am not sure where to post this, so sorry if it's wrong. I am trying to find a way to (in the desktop version) change between 3 different servers / environments e.g. via parameters. However I cannot get it to work. Does anybody know something about this or an article about?

Cheers,

Carsten

[cmfaarvang]

So after some more trial and error it works with parameters. Thanks

[cmfaarvang]

Thanks will take a look after the holidays, but is really looking for the sql way of working. I also understand that Redshift does not support M.

[Idrissshatila · Accepted solution]

Hello @cmfaarvang ,

check this https://youtu.be/BsfbfVFXQwU?si=2CeupVU2_Or6-0Hk