When trying to set up a connection to Timescale Cloud service from AWS, after clicking “Test Connection” via the AWS Console menu this error is received
Check that your connection definition references your JDBC database with correct URL syntax, username, and password. 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.
Most likely solution
Timescale Cloud defaults SCRAM for password authentication as it offers better security. However, we do allow MD5 as an alternative in case you need to access via older clients. In the case discussed in Slack, switching to MD5 fixed the issue. The may also apply to self-managed TimescaleDB too.
Possible alternative cause
The JDBC version is too old, per this discussion from Stack Overflow
Stack Overflow: Unable to connect to Postgres DB due to the authentication type 10 is not supported
Carried from an original conversation in Timescale’s community slack Thanks to Agung Pratama for confirming solution.