ELT and transformation layers

ELT (Extract, Load, Transform) first loads the raw data into the warehouse, then transforms it in place with SQL, relying on its computing power. Transformations are organized in successive layers (raw, cleaned, business), which makes it possible to replay the processing and keep the original data intact.

Example

Raw layer -> cleaned layer (types, duplicates) -> business layer (metrics).

Related concepts

The whole glossary