What is ELT?
Extract, Load and Transform (ELT) is a data integration process that moves raw data directly from source to destination for analysts to transform as needed. It differs from ETL (Extract, Transform and Load), which has been the norm in data integration. ELT extracts and loads raw data with no assumptions about how it will be used, while ETL transforms data before loading it, limiting the volume of data that is warehoused to preserve resources. The modern cloud environment enables ELT by reducing storage, computation, and bandwidth costs. Fully managed ELT solutions automate pipeline maintenance tasks, freeing up data teams' time for analysis and insights generation.
Company
Fivetran
Date published
March 30, 2022
Author(s)
Charles Wang
Word count
915
Hacker News points
None found.
Language
English