AWS Administration - The Definitive Guide - Second Edition

Connecting to your Redshift cluster

You can use a number of tools to connect to your Redshift cluster once its up and running. Most of these tools are PostgreSQL compliant and easily available off the shelf. In this case, we are going to install and use an open source SQL client tool called SQL Workbench/J.

To begin with, you will need to have Java runtime installed on your local workstation. The Java runtime version will have to match the requirements of SQL Workbench/J, otherwise it simply won't work. You can check the version of the installed Java runtime on your local desktop by either locating the Java configuration on the Control Panel or by typing in the following command in a Terminal if you are working with a Linux distribution: ...