ETL: Extract, Transform, Load
ETL moves data through three phases from sources to containers. It handles one or more inputs and outputs via software that automates the process on recurring schedules or in batches. The footgun is defaulting to manual runs when automation is typical.
ETL is a three-phase computing process that extracts data from input sources, transforms it, and loads it into output containers. It can collect from one or more sources and deliver to one or more destinations. ETL software typically automates the entire process, running on recurring schedules either as single jobs or aggregated into batches. The footgun is treating manual execution by system operators as the default when the process is typically executed using software applications.
Read the original → Wikipedia: Extract, transform, load
- #etl
- #data-pipeline
- #automation
- #batch-jobs
- #data-engineering
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.