ETL (Extract, Transform, Load)
Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources. It then transforms the data according to business rules, and it loads the data into a destination data store
ELT (Extract, Load, Transform )
Extract, load, transform (ELT) is a data integration process that moves data directly from source to destination for analysts to transform as needed
ETL VS ELT
| ETL | ELT |
| Data is extracted from a source system, transformed on a secondary processing server, and loaded into a destination system | Data is extracted from a source system, loaded into a destination system, and transformed inside the destination system |
| ETL is a time-intensive process. data is transformed before loading into a destination system | ELT is faster by comparison. data is loaded directly into a destination system and transformed in-parallel |
| data output is structured | data output can be structured, semi-structured and unstructured |
Reverse ETL
The reverse ETL feature lets you use the customer data residing in your data warehouse and route it to your entire data stack, including analytics, sales, and marketing tools
List of startups that support Reverse ETL
Grouparoo (open source)