Unable to read partition tables in Postgresql

Question & Answer
, ,
1

Hi,

I have an AWS RDS sitting in a VPC and have successfully connected to this VPC with validated user account access.

I have created a few dashboards from this Postgresql that are non-partition tables and Quicksight can read these tables.

However when I want to create a dashboard using a partition table from Postgresql, I am getting error

Your database generated a SQL exception. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.

ERROR: permission denied for table xxxx table

I have given the SELECT permission to this Postgresql user but the error persist.

Is Quicksight able to read partition tables? If yes, how should I give the permission to my user to read it?

2

Hi @dixerio

could you please try with CUSTOM SQL and access partitioned table and let us know if it works or not.

I could see similar issue raised in below post as well.

Thanks
VInod

1 Like
3

Hi @apjvinod

Since this is a bug in QuickSight and the issue has reoccured for another user I suggest you create a AWS ticket on a pro-active basis so this could be worked.

Based on the solution shared it seems that was not done the last time the issue was reported.

Regards,
Giri

4

Hi @apjvinod , using CUSTOM SQL, I can query the main partition table.

Is this a bug from Quicksight?

5

Hi @dixerio

What I meant was that you are not able to get access to the table by selecting the table from the table browser and have to resort to Custom SQL as a workaround.

Regards,
Giri

6

Hi @dixerio

Thanks for confirming its working with CUSTOM SQL , let me create internal ticket to dev team .