Set up Amazon Redshift with SQL Workbench J

• Download the zip file for SQL Workbench here at time of writing (via, where it's the link listed as "Generic package for all systems including all optional libraries")

  • I put them in ~/opt/sqlworkbench/
  • ln -s $HOME/opt/sqlworkbench/sqlworkbench.sh $HOME/opt/bin/sqlworkbench

• Download the zip file for the open source Amazon Redshift JDBC driver, which includes the AWS SDK for Java here at time of writing (via)

  • I put them in ~/opt/redshift_jdbc_driver
  • I ran sqlworkbench (which I'd previously symlinked to the bash script to run the program)
  • I clicked the 'Driver' drop down and selected 'Amazon Redshift'
  • The driver location showed up in red and I selected the redshift-jdbc42-2.1.0.3.jar file interactively at its location in ~/opt when prompted
  • The classname com.amazon.redshift.Driver was filled in automatically but did not match the one given here of com.amazon.redshift.jdbc.Driver so I changed it to add the missing 'jdbc' part.
  • The 'sample' URL of jdbc:redshift://endpoint:port/database seemed to match the one described here so I filled it in with endpoint 127.0.0.1 [and the rest were private credentials]