Step 1: Setup Amazon Redshift
What is Amazon Redshift?
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).
1. After your login to AWS, click the Services drop-down on your left-side. Then navigate to DAtabaes and finally click on Redshift.
3. Click on 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.
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.
6. In the nex step, you can add some Additional Configuration. You may use the standard defaults. Click on Continue.
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.
9. If everything goes ok then you will probably see your cluster as Available and Healthy. Click on it for details.