Loading text files to QuickSight

The easiest way to load data to QuickSight is to just upload it to SPICE, which was explained in Chapter 1, A Quick Start to QuickSight. Another alternative to uploading text files is to use S3 storage and this section will detail this flow.

Uploading a data file to S3

For this demonstration, we will use the file USAStateAbbr.csv, which has a list of USA state codes and the corresponding full names.

Note

The sample files are in GitHub at https://github.com/rnadipalli/QuickSight/tree/master/sampledata.

Here are the detailed steps to upload a file to an S3 filesystem:

  1. Download the file to your local system (laptop).
  2. Upload the file to AWS S3, login to our account, and from the Services menu select S3.
  3. Select the S3 bucket ...

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