Connecting quicksight to aws postgres

[datawispcam]

When connecting my aws postgres instance to quicksight I get an error:

region:	us-east-1
timestamp:	1726679642779
requestId:	aea5e19d-a9d2-41a7-9818-2dcacbc75d28
sourceErrorCode:	GENERIC_SQL_EXCEPTION
sourceErrorMessage:	The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client’s IP address or subnet, and that it is using an authentication scheme supported by the driver.

I would expect this to work fairly easily as they’re both aws products. Any advice?

[apjvinod]

Hi @datawispcam

Could you please share the postgre-sql version of the datasource instance . Currently we support only ‘MD5’ based password encryption , you might need to change the password encyption to MD5 as mentioned in the below community post.

My QuickSight cannot connect to RDS PostgreSQL DB via VPC

QuickSight is not working with default Postgres 14 configuration. Postgres 14 changed the default password encryption from MD5 to SCRAM (see PostgreSQL 14 and Recent SCRAM Authentication Changes - Should I Migrate to SCRAM?). This looks like requiring a driver upgrade to 42.2.0 (see java - Unable to connect to Postgres DB due to the authentication type 10 is not supported - Stack Overflow) and QS is using 42.0 (see Maven Central Repository Search). The workaround is explicitly set the password_…

Alternatively you may reach out to your AWS account team for further assistance in the non-production accounts to get beta access.

Thanks
Vinod

[Brett]

Hi @datawispcam,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial topic?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

[Brett]

Hi @datawispcam,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!

[vignessh.b]

@datawispcam @apjvinod @Brett
Amazon QuickSight 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 QuickSight. No additional configuration is needed in Amazon QuickSight 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 QuickSight, please create a support ticket.

– Amazon QuickSight Connectivity Team