Exploring RedShift | Scribe

    Exploring RedShift

    • Hafeez Baig |
    • 15 steps |
    • 2 minutes
    information ordinal icon

    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

    information ordinal icon

    **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

    information ordinal icon

    Congratulations on completing the lab and exploring RedShift! Good job!