What Is ELT (Extract, Load, Transform)?


ELT (Extract, Load, Transform) is a data integration process of moving raw data from a source system to a destination resource (e.g., a data warehouse or lake) and preparing files for downstream uses.

The ELT pipeline has three phases: extracting data (reading files from one or more source systems, such as an ERP or CRM), loading the extracted data (adding data to the target database), and transforming data (converting files from their source format to the analysis format).