ELT Definition


Extract, Load, Transform “ELT” is a modern variant of traditional “ETL”, where extracted data is loaded into a target database in its original raw format before any data transformation takes place.

The “ELT” model enables data cleansing, data enrichment, and data transformation to all occur inside the database itself. The raw data is stored indefinitely in the database, which allows for faster loading times and multiple transformations.

“ELT” has been popularized as a common data pipeline model with the advent of cloud data warehouses like, Snowflake, Microsoft Azure, Amazon Redshift, and Google BigQuery.

More from Data Management & ELT Glossary

Key terms to help you learn more about data management, ELT, and all-things Rivery