7
Data Warehousing
In this chapter, we will look at the following key topics:
- The need for a data warehouse
- Data warehousing using Amazon Redshift
- Data warehouse modernization with Redshift
- Data ingestion patterns
- Data transformation using ELT patterns
- Data security and governance patterns
- Data consumption patterns
The concept of data warehouses has existed for a long time and organizations have been able to use data warehouse systems to do online analytics processing (OLAP). Deriving analytical insights from the data from these systems is the main goal of every organization. However, as we discussed in Chapter 1, the traditional data warehouse setup became challenging in the age of cloud computing. With the ever-growing volume, velocity, ...
Get Modern Data Architecture on AWS 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.
