ERROR: The relation "table_name" does not exist in Google Data Studio

When you're using Google Data Studio to work with your Panoply data, you'll notice that some of your tables aren't displayed, mainly if they belong to other schemas aside from the public schema. This is because Google Data Studio doesn't auto-identify schemas, and only tables from the public schema of PostgreSQL or Redshift databases are displayed.

Here's the workaround for this issue:

1. Get the list of all your schemas using the query provided below. Execute it in the Workbench tool or your preferred third-party SQL client tool.

   SELECT DISTINCT nspname
   FROM pg_namespace
   WHERE nspowner > 1;
   

2. Modify your user's search_path by executing the SQL statement below. Replace the placeholders with the names of your schemas and wrap them in double-quotes.
   

   ALTER USER "your_username"
   SET search_path TO '$user', "public", "<schema1>", "<schema2>", ...;
   

3. Reconnect Google Data Studio.

NOTE: If you again add a new schema, you need to modify your user's search_path again.