Loading data from Athena to QuickSight
In this section, we will review how to use Athena, which is a new service from Amazon that enables SQL queries on S3 files without the need for any additional infrastructure.
Uploading data to S3
The dataset is available from the following public URL https://catalog.data.gov/dataset/college-scorecard.
Here are the detailed steps to upload a file to an S3 filesystem:
- Download the
CollegeScorecard_Raw_Data.zipto your local system (laptop) and unzip the file.
- To upload the file to AWS S3, login to our account and ...