Redshift Free SQL IDE

Amazon Redshift is a data warehouse product from AWS. qStudio is a free SQL IDE, it allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including Redshift.

Contents

  1. Start Redshift
  2. Connecting to Redshift
  3. Querying Redshift

Setting up a Redshift connection in qStudio

Start Redshift

As an example of starting Redshift:

  1. Go to https://eu-west-1.console.aws.amazon.com/redshiftv2/home
  2. Create a new namespace / workgroup

Redshift SQL Connection
  1. To keep this demo simple, we are making the database publicly accessible.
  2. and take note of the JDBC details.
Redshift SQL Connection Settings

Also make sure you have the security settings configured to allow your IP address to connect.

Redshift Security

Create Your User

Open the sqlWorkbench and run the below commands. Notice I also clicked sample_data_dev to add that sample data set.

Redshift SQL to Add User

Connecting to a Server

When you first open qStudio click on the menu options Server->Add Server or on the add server button on the toolbar.
Then set the details:

  1. Server Type: Redshift
  2. Connect By: URL
  3. URL: jdbc:redshift://default-workgroup.516747612486.eu-west-1.redshift-serverless.amazonaws.com:5439/dev
  4. Username: quser
    Password: OpenDoor232
  5. Click Add

Add Redshift SQl Connection

Sending Queries

You can run queries by highlighting selected code and pressing :

CommandShortcut
Run Current Statement Ctrl + q
Run highlighted text Ctrl + e
Run Line Ctrl + Enter

This will update your various results panels, result contains your table (excel export etc. supported), charts are generated based on your data and the console summarizes your recent commands

Run Redshift Select

Well Done!

You have now got qStudio querying your database successfully.

We want to make qStudio the best SQL analysis tool. If you have any problems or want additional features, please post on our github repo.