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 ...

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