/plushcap/analysis/fivetran/what-is-elt

What is ELT?

What's this blog post about?

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


By Matt Makai. 2021-2024.