Today, I want to show you an implementation of Data Warehouse on AWS based on a case study performed a couple of months ago.

This implementation uses AWS S3 as the Data Lake (DL). AWS Glue as the Data Catalog. And AWS Redshift and Redshift Spectrum as the Data Warehouse (DW).

Architecture

The architecture followed in this implementation is based on ELT processes. First, the data is extracted from sources, then is loaded into the Data Lake, and finally is transformed in the Data Warehouse.

#aws #data-engineering #data #data-warehouse #data-science