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:
- 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;
- Modify your user's
search_pathby 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>", ...;
- Reconnect Google Data Studio.
NOTE: If you again add a new schema, you need to modify your user's