What is EtLT?

Last updated Dec 14, 2022 - Edit Source

• Data engineering
• Concept

EtLT refers to Extract, “tweak”, Load, Transform, and can be thought of an extension to the ELT approach to data integration.

When compared to ELT, the EtLT approach incorporates an additional light “tweak” (small “t”) transformation, which is done on the data after it is extracted from the source and before it is loaded into the destination. This is demonstrated in the following image:

For a more detailed explanation of EtLT see: EtLT for improved GDPR compliance.