Working with Amazon Redshift

Working with Amazon Redshift

1 hora 55 minutos 10 créditos

SPL-17 Version 4.2.5

© 2020 Amazon Web Services, Inc. and its affiliates. All rights reserved. This work may not be reproduced or redistributed, in whole or in part, without prior written permission from Amazon Web Services, Inc. Commercial copying, lending, or selling is prohibited.

Errors or corrections? Email us at

Other questions? Contact us at


This lab provides an overview of Amazon Redshift. In this lab, you will launch and work with an Amazon Redshift cluster to analyze USA Domestic flight data.

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. It is optimized for datasets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions.

Amazon Redshift delivers fast query and I/O performance for virtually any size dataset by using columnar storage technology and parallelizing and distributing queries across multiple nodes. We’ve made Amazon Redshift easy to use by automating most of the common administrative tasks associated with provisioning, configuring, monitoring, backing up, and securing a data warehouse.

Topics Covered

By the end of this lab, you will be able to:

  • Launch an Amazon Redshift cluster
  • Connect to Amazon Redshift by using SQL client software
  • Load data from Amazon S3 into Amazon Redshift
  • Query data from Amazon Redshift
  • Monitor Amazon Redshift performance

Lab Pre-requisites

To successfully complete this lab, you should be familiar with basic concepts of databases and SQL.

Start Lab

  1. At the top of your screen, launch your lab by clicking Start Lab

This will start the process of provisioning your lab resources. An estimated amount of time to provision your lab resources will be displayed. You must wait for your resources to be provisioned before continuing.

If you are prompted for a token, use the one distributed to you (or credits you have purchased).

  1. Open your lab by clicking Open Console

This will automatically log you into the AWS Management Console.

Please do not change the Region unless instructed.

Common login errors

Error : Federated login credentials

If you see this message:

  • Close the browser tab to return to your initial lab window
  • Wait a few seconds
  • Click Open Console again

You should now be able to access the AWS Management Console.

Error: You must first log out

If you see the message, You must first log out before logging into a different AWS account:

  • Click click here
  • Close your browser tab to return to your initial Qwiklabs window
  • Click Open Console again

Task 1: Launch your Amazon Redshift Cluster

You will now launch an Amazon Redshift cluster, which starts your very own database for use in this lab.

  1. Wait until the status of Provisioning lab resources gets complete.

This indicates that required resources are available for your lab.

  1. In the AWS Management Console, on the Services menu, click Amazon Redshift.

  2. If you see a page that says Welcome to the New Amazon Redshift Console, click Get started

  3. At the top-right of the screen, if you see Try the new UI, click it.

  4. In the left navigation pane, hover over CLUSTERS, then click Clusters.

  5. Click Create cluster then configure:

  • Node type: dc2.large
  • Nodes:

This lab uses the dc2.large node size, which has 160GB of storage per node. You will be using a single node for this lab, but the type and number of nodes in a Redshift cluster can be changed at any time to provide extra storage and faster data processing.

  1. Scroll down to the Cluster details section, then configure:
  • Cluster identifier:
  • Master user name:
  • Master user password:
  1. Expand Cluster permissions, then configure:
  • Available IAM roles: Redshift-Role
  • Click Add IAM Role
  1. Next to Additional configurations, click the slider to not use the defaults.

  2. Below Network and security, configure:

  • Virtual private cloud (VPC) Lab VPC
  • VPC security groups:
    • Select Redshift Security Group
    • Remove Default

If you cannot see the Redshift Security Group, confirm that you have changed the VPC.

These settings define the network and security configurations for the Redshift cluster.

  1. Expand Database configurations.

  2. For Database name, enter

  3. Click Create cluster

  4. Click the lab link.

  5. Click the Properties tab.

This shows the property details for your cluster.

Your cluster can take up to 5 minutes to launch.

While you are waiting, please continue reading the next section.

Participe do Qwiklabs para ler o restante deste laboratório e muito mais!

  • Receber acesso temporário a Console da Amazon Web Services.
  • Mais de 200 laboratórios, do nível iniciante ao avançado.
  • Tamanho compacto para que você possa aprender no seu próprio ritmo.
Participe para iniciar este laboratório