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, and variety of data in recent times, traditional on-premises data warehouses are not able to handle all the new use cases businesses users wish to solve.
