ETL & ELT, a comparison

When designing and building data pipelines to load data into data warehouses you might have heard of the common ETL and ELT paradigms. This post goes over what they mean, their differences and which paradigm you might want to choose. If you are wondering why we have a staging area click here. ELT is very similar but the data is loaded into a table before being transformed to a final table which is used by users. As you can see it has fewer components compared to the ETL approach.