Different resources for the same query

Hi everyone! I am trying to write tests using the testing feature. And I would like to create a local Postgres DB instance resource to use in tests because I don't want to touch real data in prod DB. And I want to use 2 different resources: local resource from queries I run in tests and prod resource from actual queries. Is it possible to do it in retool?

Hey @Ekaterina_Klementeva!

This should be possible using environments - you can set up your resources to have a "Staging" or "QA" environment with different settings/credentials.

If you then select that environment in the front end when running your test it should hit the corresponding db for all queries you run.

Does that seem like it could work?
Feb-16-2023 15-59-34.mp4