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 QuickSight, Building 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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial