Set up Amazon Redshift with SQL Workbench J - lmmx/devnotes GitHub Wiki

  • 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]