Extract Transform Load (ETL)

An Extract Transform Load (ETL) is an automated process that extracts data from one or more sources, transforms it to meet the needs of one or more data products, and loads the transformed data to a host database or data warehouse. ETLs are the building blocks of data pipelines.

Transformation can include splitting, combining, adding, removing, aggregating, or otherwise reshaping data to fit a particular use case or next step in a lager data pipeline.