AWS Data Wrangler Series - Part3- Working with Amazon Redshift

   Go back to the Task List

  « 2. Create IAM Roles    4. Create Private Link »

3. Launch Redshift Cluster

You launch a Redshift cluster which is used as the data source in the AWS Wrangler based code.

  1. Goto Redshift Management Console and click on the Create cluster button.

    Redshift

  2. On the next screen, type in dojoredshift for the cluster identifier and select Free trial option.

    Redshift

  3. On the same screen, in the Database configurations section, type in Password1! for the master user password field. Keep rest of the fields as the default.

    Redshift

  4. It will take a moment to create the Redshift cluster. Wait till the status of the cluster changes to Available.

    Redshift

  5. Few things to remember about the cluster which will be useful later.

    cluster identifier: dojoredshift

    username: awsuser

    password: Password1!

    database: dev

  6. The cluster is ready. In the Redshift Management Console, click on the EDITOR menu in the left. It will open the Connect to database popup. Select Create new connection option. Select dojoredshift as the cluster. Type in dev for the database. Type in awsuser for the user and Password1! for the password. Finally click on the Connect to database button to connect to the cluster.

    Redshift

  7. On the next screen, run the following SQL statements one by one to create table dojotable and then insert three sample data into it.

    Redshift

    create table dojotable
    (
        firstname varchar,
        lastname varchar,
        age int
    );
    

    `

    Redshift

    insert into dojotable values ('James','Smith',34),('Henary','Club',41),('Jony','Whack',25);
    

    `

  8. The Redshift cluster and data is ready. Let’s move on to Glue configurations.