How do I alter the search_path to refer to a different default organization?

Issue

When accessing the data warehouse, the default organization is the first organization that the user navigates to. However, users may want to change this default afterwards, like if the original organization has fallen out of use.

Without changing the search path, the only way to reference another organization is to use the organization prefix for every table.

Environment

Data warehouse

Cause

When accessing the data warehouse, the default organization is the first organization that the user navigates to, and there is no straightforward way to change it.

Resolution steps

Have the user try the following steps in their client:

1. SHOW search_path; /* get the current search path string */
2. ALTER ROLE <login-role-name> SET search_path='<list of schemas to search>'; /* change the search path to meet expectations to eliminate prefixes */
3. Then log out, log back in and the search_path should be updated to the new values, should not need to prefix the tables anymore.