Switching from dev DB to prod DB

  • What are you trying to achieve?
    Have a junior developer working on queries for panels on a dashboard. Due to security reasons they are only allowed to use Dev DB for query writing. However to put this dashboard to actual use we need these queries to be running on Prod DB. This issue is addition of panels on this dashboard is ongoing, we keep adding new panels. How to smoothly transition between dev DB and Prod DB without giving access to junior developer.