The SQL Workbench provided as a SQL tool for Redshift Database development and analysis. I wondered if it would be possible to configure Oracles SQL Developer to connect to a AWS Redshift instance.
It is possible, but only gives basic administration, but is worth keeping an eye on just in case future releases provide more functionality. Steps and demo below
- Browse to URL http://jdbc.postgresql.org/download.html and download the latest JDBC driver available
- Open SQL Developer and go Tools>Preferences, add the JDBC driver to the Third party driver section ( see below )
- Create a new connection, providing the username,password,host and port number. There is a small bug, which means the database drop down list will only appear if the username you enter to connect matches the AWS database name. You can use the create user scripts below to have the DBA create a user that allows you to connect.
- Once connected you can browse the schema, and run SQL, but explain plans etc look to be restricted. (see screenshot below )
- Below are some statements, that as a super user within the SQL Workbench allow you to create a super user within Redshift AWS Database :-
–Create Uses
–This creates a super user
Create user hlc createuser password ‘apassword’
alter user hlc createuser;