Data Studio
2.5K members online now
2.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Can't query AWS Redshift tables not in the "public" schema (PostgreSQL connection)

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,
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?

 

Can't query AWS Redshift tables not in the "public" schema (PostgreSQL connection)

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hey Davide, I had the same problem with Postgres and noted it on this thread:

https://www.en.advertisercommunity.com/t5/Data-Studio/Getting-configuration-error-on-PostGres-Data-S...