Using a hands-on lab approach, explore how to use Amazon Redshift to set up and configure a data warehouse on the cloud. Discover how to interact with the Redshift service using both the console and the AWS CLI.
Learning Objectives
Scalable Data Architectures: Introduction to Amazon Redshift
- use the Amazon Redshift Quick Launch feature to provision a data warehouse on Amazon Web Services
- define additional configuration options when provisioning a Redshift cluster by using the default cluster
- recognize the various tool configuration options available for a Redshift cluster and use the metrics available to optimize a cluster configuration
- create an IAM role on AWS that includes the necessary permissions to interact with the Redshift and S3 services
- provision an IAM user that can be used to connect to and interact with AWS using the CLI
- install the AWS command line interface and use it to create and delete Redshift clusters
- use the Redshift Query Editor to create tables, load data, and run queries
- recall the features of Amazon Redshift and the commands and configurations needed to work with Redshift using the CLI