Can't query AWS Redshift tables not in the "public" schema (PostgreSQL connection)
I'm using the PostgreSQL connection to connect DataStudio to an Amazon Redshift database.
When adding the DataSource, DataStudio correctly lists all tables in all schemas.
When actually querying the data, it works fine with tables in the default "public" schema, but it's not possible to query tables in other schemas.
Any visualizations show an error like the following:
There`s a query error. Error ID: 299d530b
I tried both with a read-only Postgres user (with read privileges on all schemas and tables) and with a superuser.
Any solution for this?