Creating this to address questions in the community regarding SCRAM support for Quick Sight-PostgreSQL data sources.
Amazon Quick Sight now offers the latest PostgreSQL driver version for the connectors: RDS hosted PostgreSQL, Aurora PostgreSQL and Vanilla PostgreSQL thereby supporting SCRAM based authentication to PostgreSQL from Quick Sight. No additional configuration is needed in Amazon Quick Sight as long as you use the appropriate PostgreSQL engine version and have the correct configurations in PostgreSQL for SCRAM. If you still see any issues around establishing a SCRAM authentication to PostgreSQL from Quick Sight, please create a support ticket.
– Amazon Quick Sight Connectivity Team
2 Likes