Getting Started with Amazon Redshift

Lab Steps

lock
Logging in to the Amazon Web Services Console
lock
Creating the Redshift Cluster
lock
Connecting to the Virtual Machine using EC2 Instance Connect
lock
Retrieving the Redshift IAM role
lock
Loading data into Redshift
lock
Running sample queries
lock
Resizing the cluster
lock
Cleaning up the environment

The hands-on lab is part of these learning paths

Solutions Architect – Professional Certification Preparation for AWS
course-steps
48
certification
7
lab-steps
19
quiz-steps
4
description
2
Working with AWS Databases
course-steps
11
certification
3
lab-steps
5

Ready for the real environment experience?

DifficultyBeginner
Time Limit1h 45m
Students1477
Ratings
4.6/5
starstarstarstarstar-half

Description

Amazon Redshift is a managed data warehouse that allows you to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools. Redshift uses query optimization, columnar storage, parallel execution, and high-performance disks to query petabytes of data in seconds. Redshift is valuable for companies that use SQL or existing BI tools and want to analyze large amounts of data with their existing tools. In this Lab, you will learn how to create, query, and resize a Redshift cluster.

Learning Objectives

Upon completion of this lab you will be able to:

  • Log in to the AWS Management Console
  • Use EC2 Instance Connect to communicate with Redshift
  • Create and resize a Redshift cluster
  • Load data into Redshift
  • Query data with Redshift

Prerequisites

You should be familiar with:

  • Basic understanding of the Linux bash shell
  • Conceptual understanding of SQL and Redshift

Lab Environment

Before completing the lab instructions the environment will look as follows:

After completing the lab instructions the environment should look similar to:

Updates

July 22nd, 2020 - Updated all instructions and screenshots

May 13th, 2020 - Migrated to Instance Connect

January 10th, 2019 - Added a validation Lab Step to check the work you perform in the Lab

November 21st, 2018 - Updated Lab to use the new default dc2.large instance type and modified the Lab permission policy to allow resizing the cluster to account for IAM changes in Redshift

About the Author

Andrew is a Labs Developer with previous experience in the Internet Service Provider, Audio Streaming, and CryptoCurrency industries. He has also been a DevOps Engineer and enjoys working with CI/CD and Kubernetes. He holds the AWS Certified Developer - Associate certification.