ETL vs ELT | Dataform

ETL vs ELT

Cloud data warehousing is changing the way companies approach data management and analytics. Cloud warehouses which store and process data cost effectively means more and more companies are moving away from an ETL approach and towards an ELT approach for managing analytical data.

E

Extract

Source data is extracted from the original data source in an unstructured format. In traditional ETL processes this data is put into a temporary staging repository such as S3.

L

Load

In the ELT model, data is copied then pasted directly into the data warehouse without significant modification. In an ETL model, data would be transformed into a suitable format before loading it into the warehouse.

T

Transform

Once loaded into the data warehouse, additional transformation must be done to clean and model data before it can be practically useful for other analytics applications, particularly when following the ELT model.

What is ETL?

ETL requires the transformations to happen before the loading process. ETL extracts data from data sources and then deposits it into a staging area. Data is then cleaned, enriched, transformed and finally loaded into the data warehouse.

What is ELT?

ELT is a modern variation of ETL where data cleaning, enrichement and transformation happen after the loading process. This is enabled by the fact that modern cloud data warehouses are extremely scalable and seperate storage from compute resources.

Kaleva
Livup
Echo
Charlotte Tilbury
Curology
Big Tree
Teatime Games
Slite
Tasman Analytics
Butternut Box
Outshine
Dreamdata
Mittelbayerische

Learn more about Dataform's ELT platform

Dataform brings open source tooling, best practices and software engineering inspired workflows to advanced data teams that are looking to scale, helping you deliver reliable data to the entire organization.

What our customers say

Benoit Photo
Benoit Machefer

Director of Data

If your business is scaling fast and you want to ensure data quality, make your life easier, leverage engineering best practices and remain BI tool agnostic then don’t hesitate to use Dataform for a second!

Echo Logo
speech marks
Saadat Photo
Saadat Qadri

Analytics Practice Lead

Having modeled data using other tools in the past, this is much simpler and an easier environment to code in. The code compiles in real time and lets you know if there are errors in the syntax. It also helps generate a dependency graph for the data pipeline which is insanely useful.

Outshine Logo
speech marks
Will Photo
Will Misslin

Data Engineer

After using Dataform for a while I really discovered the power of integrating an IDE with an ETL tool. The web based IDE completely eliminates the hassle of maintaining local dev environments.

Curology Logo
speech marks