Step 1: Setup Amazon Redshift

What is Amazon Redshift?

Amazon Redshift is one of the most popular data warehousing solutions which is part of the Amazon Web Services (AWS) ecosystem. It is a petabyte scale, fully managed data warehouse as a service solution that runs on the cloud. It is SQL based and you can communicate with it as you would do with PostgreSQL.

How to setup an Amazon Redshift Instance?

Setting up a Redshift Instance is easy. Though, you will need to decide on its type. There are two types, the Dense Compute and Dense Storage.

Dense Compute has less storage but it has better performance and speed. The more data you are querying, the more compute you need to keep queries fast. This is the type of instances to use if you need a high-performance data warehouse.

The Dense Storage cluster is designed for big data warehouses. So, if you have too much data to fit.

Setup a new Redshift Cluster

You can skip this step if you already have a Redshift cluster.

We’ll start with the simplest cluster setup possible — a cluster in EU-West not in any VPC. This kind of setup is best used for prototyping.

Go to your Amazon AWS account

If you have an account in AWS, you can log in here (You may set up a new one too).

setup an Amazon Redshift Instance

AWS Portal

1. After your login to AWS, click the Services drop-down on your left-side. Then navigate to DAtabaes and finally click on Redshift.

setup an Amazon Redshift Instance

3. Click on Launch Cluster.

Setting up Amazon Redshift

Click “Launch Cluster”

4. Now we will need to setup our cluster.

Cluster Identifier: Give it a name
Database Name: This optional. You can give one that you want.
Master User Name: Provide a Username of master user of the cluster
Master User Password: the Password 🙂

If you are ready, click on Continue.

Setting up Amazon Redshift

Fill in the details

5. Let’s configure the Node.

The setup bellow is as provided by AWS. It is OK for a Single Node. We ill leave it as is. Click Continue.

Setting up Amazon Redshift

Node Configuration

6. In the nex step, you can add some Additional Configuration. You may use the standard defaults. Click on Continue.

Setting up Amazon Redshift

Additional Configuration

7. In the next page review your settings and click Launch Cluster.

8. Then you will see a page saying that your cluster is being setup. Click on the link to see your cluster in the dashboard. Wait for a few minutes and it should be up and running.

Setting up Amazon Redshift

AWS Redshift cluster dashboard

9. If everything goes ok then you will probably see your cluster as Available and Healthy. Click on it for details.

Next Steps:

In the next section we will see how to define networking and security settings for your Redshift instance. That will help you to permission Blendo to Amazon Redshift in order to send your data.

READ NEXT: Step 2: How to setup the Amazon Redshift permissions

Questions? Contact us!

in Amazon Redshift