Exploring RedShift
- Hafeez Baig |
- 15 steps |
- 2 minutes
Refer to the following guide to learn how to use IAM in the cloud\
<https://scribehow.com/shared/Creating_an_IAM_User_and_User_Group_in_AWS_Management_Console__hWNiiXlcRJKFqYZZEJD-cg>
1
Sign in to **AWS Management Console** as an **IAM User**
**Pre-requisite** - Ensure you have selected the AWS region closest to your location\
For this guide, we will be using us-east-1 (N. Virginia) as a preferred choice
2
Type **Amazon Redshift** in the search bar and click on **Amazon Redshift** to view the Amazon Redshift page
3
On the **Amazon Redshift** page click on **Create cluster** on the right side of the page
**What is a cluster in Amazon Redshift?**
A cluster in Amazon Redshift is a fully managed data warehouse solution designed for analyzing large datasets.
4
The Cluster creation wizard will open, under the **Cluster configuration** section give the **Cluster identifier** as "**redshift-cluster-1**"
Choose the size of the cluster as **I'll choose** and select the Node type
5
Scroll to the **Configuration summary** section to review the cluster's configuration details and its cost
6
Scroll to the **Database configurations** section and specify the Admin user name as "**awsuser**", and under the Admin password section select **Manage admin credentials in AWS Secrets Manager**
7
Scroll to the **Cluster permissions** section, Here you can manage the permissions for the clusters, including configuring **IAM roles** as needed
8
Scroll to the **Additional configurations** section and configure any additional settings for the cluster as needed, or leave them as default
9
Scroll the page and click on **Create Cluster** button to initiate the Cluster creation process
10
To set or view Queries and Loads, click on the **Queries and Loads** option from the left bar
11
**Queries and Loads** wizard will open, where you can view and manage your queries and loads
12
To edit your query, click on the **Query editor** option from the left bar
13
The Query Editor wizard will open, where you can add queries
On the right side, you can click on the **Connect to database** button to connect to the database
14
To view the Endpoints of the cluster, click on the **Configurations** option from the left bar
15
The Configurations wizard will open. On the right side, click on the **Create endpoint** button to create an endpoint
Congratulations on completing the lab and exploring RedShift! Good job!