A handy post to note down the JDBC client driver download. I’m frequently in need of this myself.
You can download the JDBC driver from the AWS Docs and then gain your cluster endpoint address from the main Redshift dashboard window
Instead of doing the above, you navigate to the Configure tab in the Redshift console and download the JDBC driver & grab the endpoint address below it. Click Step 2 for the driver download in this area.
Once downloaded you can amend your query app JDBC driver. I’m using DBeaver and have deleted & replaced the .jar file.
All I’ve changed is the Redshift host address, database name and login details. The test connection works!
and I’ll just create a test database….