Getting Started
1. AWS Console Login
2. AWS Cloud Formation Parameters
Lab
1. Business Requirements
2. Lab Goal
3. Connect to Amazon Redshift
4. Create External Schema
5. Create Tables
6. Data Ingestion
7. Review Tables
8. Analyze product review data
9. Unload to data lake
10. Inspect Queries
Additional Resources
© 2019 Amazon Web Services, Inc. or its Affiliates. All rights reserved.
Amazon Redshift Schema Design and Data Ingestion Lab
> Lab
Lab
Flow of the Lab
Business Requirements
Goal
Connect using Amazon Redshfit Query Editor
Create External Schema to query external tables using Amazon Redshift Spectrum
Create Tables
Data Ingestion
Review Tables
Analyze product review data
Unload to Data Lake
Inspect Queries