How to Build a Redshift Data Warehouse
There's nothing convenient or easy about having a large amount of data scattered across different data stores and in different formats. It can be difficult to analyze or interpret, yet this data may contain extremely valuable information for your business. What you need is a data warehouse--a centralized place that contains all of your data and is easily queryable to quickly give you the answers to your most pressing questions.
Redshift allows for fast queries regardless of how much data you have. Check out this video from Amazon for a quick overview of how Redshift works.
What You'll Need
Your input data. You will need access to the input data that will power your data warehouse. This may involve reading data from Amazon's Simple Storage Service (S3) or reading directly from a database like MongoDB.
A Mortar account. You can request a free trial of Mortar here. You'll only pay for your actual usage of AWS cloud services (we never add an upcharge).
This tutorial breaks down the process of building your data warehouse into clear, sequential steps so that you'll always know where you are in the process and what comes next.
Ready to get started? The first thing you'll want to do is quickly explore How Mortar Works.