Loading Redshift data to QuickSight

In this section, we will look into the data flow path from the US census to QuickSight using a Redshift data store. The source data is obtained from the public site and provides information about household income and population in the USA by zip code. The path to get to QuickSight involves the following steps:

1. Uploading data to S3.

2. Creating an AWS Data Pipeline to load data from S3 to Redshift.

3. Loading data from Redshift to QuickSight.

Pre-requisites

The following are the pre-requisites to load data from Redshift to QuickSight:

• Must have a Redshift instance created.

• Data file must be a CSV. It cannot contain a header in the data file.

• You must have a database username and password that can connect to the database from QuickSight with the SELECT permission on some system tables so that QuickSight can estimate the table size. These tables are pg_stats, pg_class, and pg_namespace.

Uploading data to S3

For this demonstration, we will use the file USACensusSalarybyZip...