Unexpected Error when connecting to redshift

[nvsravank]

Description

We are using IAM SSO connection to Redshift cluster.
The cluster is standard cluster (Not serverless).
When connecting to the cluster using the direct cluster jdbc path the connection works properly.
When connecting to the cluster through a DNS name, the connection errors out.

Both connection strings work with SQL Workbench/J but not with DBeaver.

Attached is the debug log where the only thing done after start up is to open the connection.
dbeaver-debug - Copy.log

The SSO seems to work fine, the browser page opens correctly and I do get the success message from the SSO process.

DBeaver Version

Community Edition Version 24.0.3.202404211624

Operating System

Windows 11

Database and driver

Redshift database
AWS Redshift JDBC driver
Full details of all the libraries and versions used in the attached screen shot.

Steps to reproduce

I try to connect to the database.
The browser window for SSO comes up.
SSO is successful.
On switching back to dbeaver, the error popup comes up.

Additional context

No response