Athena Basics
DataSets
To demonstrate the basic Athena capabilities, a simple synthetic data set will be used.
We will be using the following datasets for Athena basic labs:
- Customers - A set of synthetic customer records (~96,000)
- Sales - A set of synthetic sales records linked back to a customer (~287,000)
In this step, we will connect to our EC2 servers, located in both the public and private subnets.
Content
3.1. Prerequisites
3.2. Load Datasets
3.3. Create Tables
3.4. Create Tables with Glue
3.5. Create Views
3.6. Query Results Re-Use
3.7. Query Results and History
3.8. ETL with Athena CTAS
3.9. Athena Workgroups
3.10. Visualize with QuickSight using Athena