Contact

ETL (Extract, Transform, Load)

Category
Cloud & data
In Hungarian
ETL (kinyerés, átalakítás, betöltés)
Entry
23 / 90

In short: What is ETL (Extract, Transform, Load)?

ETL (extract, transform, load) is a data pipeline that extracts data from source systems, standardises it and loads it into a target database.

Explanation

The three stages are reading raw data from source systems, transforming it (cleaning, normalising formats, joining records, computing derived fields) and loading the result into a data warehouse. A common modern variant is ELT, where transformations run inside the target warehouse itself.

Reliable data pipelines are the foundation of analytics: if ingestion is broken or incomplete, every downstream dashboard will be too. Pipelines therefore need scheduling, monitoring and fault-tolerant retry logic.

Example: an overnight job pulls the previous day's orders, converts amounts into a common currency, joins customer master data and refreshes the reporting tables.

All terms from A to Z

Have an idea or an engineering challenge to solve?

Let's talk