Rapidly create and deploy powerful Java applications that integrate with Amazon Redshift data. Driver version 2.1.0.6 Redshift version 5 Client Operating System Mac OS 12.3.1 (21E258) DBeaver Version 22.05011839 Problem description Expected behaviour: Connect to Redshift through IAM authentication Actual behaviour. The Redshift JDBC Driver enables users to connect with live Redshift data, directly from any applications that support JDBC connectivity. SQL Workbench tool is one of the SQL editors for Amazon Redshift database cluster for managing data warehouse on cloud and Redshift connection can be created using JDBC driver. DBeaver comes with plenty of great features such as metadata and SQL editors, ERD, data export/import/migration and more. It is useful for developers, SQL programmers, database administrators and analysts. I have tried manually downloading it and using it, and also allowing DBeaver to download it within the driver. DBeaver is a free, multi-platform database tool that supports any database having a JDBC driver. FYI, I am running the Redshift 2.1.0.1 JDBC driver. The fields of the preceding format have the following values. The JDBC URL has the following format: jdbc:redshift:// endpoint: port / database. But, I'm also wondering if this is in the driver package itself, somewhere. Before you can connect to your Amazon Redshift cluster from a SQL client tool, you need to know the JDBC URL of your cluster.

I made a couple of crude changes (just to confirm that) and noticed now I am able to insert 1M records in 8 mins. Easily connect live Amazon Redshift data with Java-based BI, ETL, Reporting, & Custom Apps. Seems like it might be an artifact of the DBeaver plugin.xml for .serverType. These parameters are specific to Microsoft Azure AD. I checked further and noticed the problem is in the Redshift JDBC Driver class PGEscaper which becomes exponentially slow with the number of question marks in the INSERT statement. To create the identity provider in Amazon Redshift, run the following command after replacing the parameter values issuer, clientid, clientsecret, and audience.

Redshift jdbc for dbeaver