Unable to update our postgres data source

šŸ’¬ Queries and Resources
1
  1. My goal: update the Postgres connection so queries start executing against the right DB.
  2. Issue: I have updated our Postgres connection detail to use the new host ip, however my query that uses this Postgres resource is still sent to old host ip.
  3. Steps I've taken to troubleshoot:
    1. Verified data shows up correctly in new Postgres DB via another 3rd party query tool
    2. Verified IP address is correct
    3. Verified resource is indeed updated with the new ip address
    4. Verified the IP address update happened in the right environment. This resource has two environments.
  4. Additional info: (Cloud or Self-hosted, Screenshots)
    1. image
      image1030Ɨ183 20.8 KB
    2. Descript Production (Read-only) has the correct IP address in staging environment
    3. imageIā€™m testing this query on staging environment.