Redshift SQL GUi Builder

Amazon Redshift is a data warehouse product from AWS. Pulse is a free SQL Application builder, it allows creating real-time updating charts/tables and linking them interactively. 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 Pulse

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 Pulse 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 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 Pulse querying your database successfully.

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