Create Amazon Redshift Cluster
![](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/McupQC9vMKjufzN5uxWGIDHXXeflAi3CacbsjZ8C.png)
Amazon Redshift is a fast, scalable data warehouse that makes it simple and cost-effective to analyze data across data warehouse and data lake. With a few clicks, we can create a Amazon Redshift cluster in minutes.
In this article we are going to setup & deploy an Amazon Redshift Cluster.
We can deploy a new data warehouse in minutes and save time with automated administrative tasks that manage, monitor, and scale data warehouse. Amazon Redshift is fast, simple, cost-effective data warehouse that can extend queries to data lake as well.
![Amazon Redshift Clusters](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/DzJrL7cjYq0H8wBTOJr5lS5bSx8zeNVjUrkCze1O.png)
Before we start to deploy our first Redshift cluster, as a prerequisite let us setup few resources like Security Group, IAM Policies & Roles.
First we create a Security Group with access to Redshift on port 5439 restricted from our VPC.
![Security Group](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/s4ILX9BiJEBuhG1Y7X5QtueITn18iMN93F41t5sE.png)
Next we will create an IAM Policy to access our S3 buckets to read & write datasets from Redshift.
![IAM Policy<br>](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/MFxS8W3kETLfPanzOmDlA7RydLeBZXSCkOsIjckd.png)
Next we will create an IAM Role to allow Redshift to access other AWS services on our behalf.
![IAM Role](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/ApJLn33YpcErfyhC0pBtqn3WLfIwmI4PTKgCthlR.png)
Trust Relationship entities that can assume the role and the access conditions for the role redshift.amazonaws.com
{
"Version": "2012-10-17",
"Statement": [
{
"Sid": "",
"Effect": "Allow",
"Principal": {
"Service": "redshift.amazonaws.com"
},
"Action": "sts:AssumeRole"
}
]
}
Next we will set up Redshift Cluster Subnet Groups & Parameter Groups.
![Redshift Configurations](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/HyLO7q9pHB0Mrjl24BQaOMIa4rMmPorn4KAO2fXN.png)
Click on the Create subnet group button.
![Redshift Cluster Subnet Group](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/BqpkX77TKQjs25IxvVytWVeqryUHhyNTFlxu1NJc.png)
Add a name & description to the Cluster subnet group.
Next, we will select our VPC & choose the Private subnets across the various Availability zones. Finally click the Create cluster subnet group button.
![Create Cluster Subnet Group](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/e3mriO2wdeVXgCm5yFQiew02D4tgEexgcrzzNLpm.png)
Next from the Configurations menu, click on the Workload management link.
![Cluster Subnet Group](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/WCcEolEpwj1Idvc5mljrPROcvSJlmMmXRyynyyGU.png)
Now let us create a new Parameter group.
![Workload Management Parameter Groups](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/k4IEbQf1RC3mfi3MeWluHAxp5fqDgGMpvtgAPn4Y.png)
Enter the Parameter Group name and a description.
![Create Parameter Group](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/83iv75Vw1cVByCZUWgDuiqXNwGq8MICDhg4DnRJ2.png)
Modify the cluster parameters as needed. For the demo, let's keep it AS-IS.
![Cluster Parameter Group](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/880VDgaScJC6IRyQrD1CXPpyqAjiVXQMO1gPZG7J.png)
Next, click on the Clusters menu link. Now we are ready to setup our first Redshift cluster. Click on Create cluster button.
![Create Redshift Cluster](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/1RgURdCKaCZAujvMBancVYg7ZuGMe9AAyaFwn2H1.png)
Let's name the cluster & select the Node type as dc2.large. For our demo it is good to start with 1 node in the cluster.
![Cluster Configuration](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/YLM6s2FfWr5X5SvieIdWecW1sG260DlrenMNtIDd.png)
Choose a database username & password for the login credentials.
Next, select the IAM role we created earlier, from the dropdown menu & associate it with the Redshift cluster.
![Cluster Permissions](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/Zg0APv6SPe6KET26rgWukpZGfEXoWDi8YJ8zNZCb.png)
Let's select our VPC & Security group for the Redshift cluster.
Next, select the Subnet group we created earlier, from the dropdown menu & choose one of the availability zone.
Let us also disable, the public access to our Redshift cluster.
![Network & Security](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/wINBv3aU5mHnNMQ31v5e7WLOGY83fcO1LhR09KdU.png)
Let's add an initial database to the Redshift cluster. The default Redshift cluster port is 5439.
Next, select the Parameter group we created earlier, from the dropdown menu.
![Database Configurations](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/GbwPWV2BUErBjcKwYJloIE4JaoO4iGjgkCGfUtJs.png)
For the demo, lets keep the Default Maintenance window settings.
![Cluster Maintenance](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/TAwzeVDtWhsfASWAg7WvtC1XSAIJdUhdfZZTXOuX.png)
For the demo, lets keep the Default Snapshot retention as 1 day.
![Cluster Backup](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/CKidiu0RpZem6M1YM3uYMl9CDMK9CZ4kPxMnWHWC.png)
Now that all the configuration setup is done let's click on the Create cluster button. After a few minutes our Redshift cluster will be available.
![Redshift Cluster Available](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/Scg0JGkRAkxSPLoSfiiUvxEYN0mGptGjZtxwfkuS.png)
Verify the configuration & properties of the Redshift cluster. New let go ahead and do some data analysis using Redshift. Click on the Query data button followed by Query in query editor link.
![Redshift Cluster Query Data](https://d1y19n2ra9pfoy.cloudfront.net/dwbi.org/media/x9KzyrzX8L6nRuWQuuQIZLyJltTwym64HrNSamgk.png)
In our next article we will perform data analysis using Redshift & visualization on top of it using Metabase.