The hands-on lab is part of these learning paths
Ready for the real environment experience?
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.
Upon completion of this lab you will be able to:
Log in to the AWS Management Console
Connect to an EC2 instance to communicate with Redshift
Create and resize a Redshift cluster
Load data into Redshift
Query data within Redshift
You should be familiar with:
Basic understanding of local operating system and computer use
- Secure terminal connection software such as Terminal (macOS) or PuTTY (Windows)
Before completing the lab instructions the environment will look as follows:
After completing the lab instructions the environment should look similar to:
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
Eric is a Lab Researcher and Developer working to add to Cloud Academy's library of hands-on labs. He is an IT veteran who enjoys the ever-changing landscape of cloud computing. He also relishes live classical music performances, because sometimes engineering is better heard than seen.