Data Glossary 🧠
Search
What is ELT?
ELT (Extract, Load, and
Transform
Data transformation is the process of converting data from one format into a different format. Reasons for doing this could...
Data integration is the process of combining data from disparate source systems into a single unified view. This can be... A Data Warehouse, in short DWH, also known as an Enterprise Data Warehouse (EDW), is the traditional way of collecting data as...What is data transformation?
What is Data Integration?
What is a Data Warehouse?
ELT is in contrast to the more traditional
ETL ETL (Extract, Transform, and Load) is a paradigm for moving data from one system to another. It involves reading data...What is ETL?
The shift from the ETL paradigm to the ELT paradigm has been made possible thanks to the plummeting cost of cloud-based computation and storage, and the appearance of cloud-based data warehouses like Redshift, BigQuery, or Snowflake.
The following image demonstrates the ELT approach to data integration – in this diagram dbt creates and manages the SQL that is used for transforming the data in the destination:
ELT is also related to Reverse ETL which you can find more information about at: Reverse ETL Explained or Airbyte.com.