Using RLS enables POSTGRESQL db in the Quick Sight DataSource

[Xclipse]

Hi @ashikrahman

Quick Sight can’t run SET. Custom SQL in Quick Sight must be a single SELECT statement (no SET, no multi-statements, no stored procs).

Create an RLS rules dataset that maps users/groups to allowed keys, then apply it to your dataset. This is fully supported and maintained by AWS (note the new Rules dataset flag added in 2025).

Please refer to the below documentations this might be helpful for you.

Using row-level security in Amazon Quick Suite - Amazon Quick Suite

Action Required: Amazon Quick Sight Introduces Rules Datasets Flag for Row Level Security (RLS) Datasets

Action Required: Amazon Quick Sight Introduces Rules Datasets Flag for Row Level Security (RLS) Datasets Summary: On March 31st 2025, Amazon Quick Sight launched a new feature that distinguishes between regular datasets and Rules datasets used for Row Level Security (RLS). This distinction for Rules dataset has been automatically flagged (both console and API) for RLS datasets applied to regular datasets before March 31 2025. This change requires action from dataset authors and admins when deal…