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

For this demonstration, we will use all of the files for CollegeScorecard from Data.gov as discussed in Chapter 1, A Quick Start to QuickSightBuilding your first analysis under 60 seconds section.

Note

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:

  1. Download the CollegeScorecard_Raw_Data.zip to your local system (laptop) and unzip the file.
  2. To upload the file to AWS S3, login to our account and ...

Get Effective Business Intelligence with QuickSight now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.