Back to the Index

ELT

What is ELT? 

ELT stands for Extract, Load, and Transform of data. ELT is a process whereby a system first extracts data from various sources and then loaded as-is into a data warehouse. Finally, the data is transformed directly in the data warehouse (normally using SQL) into a standardized format suitable for analysis/ML. Compared to the traditional ETL process, where data is transformed in an external engine, like Spark, before it is loaded into the warehouse, in ELT, the data is transformed in-place using SQL in the data warehouse.

Where is ELT important in ML systems?

ELT is often found in feature pipelines that extract data from existing data stores, load it into a data warehouse or feature store, and then transform the raw data into features in the data warehouse or feature store.

Interested for more?

Does this content look outdated? If you are interested in helping us maintain this, feel free to contact us.
E
AI Lakehouse
AI Pipeline
Auto-regressive Models
AutoML
E
Backfill features
Backfill training data
Backpressure for feature stores
Batch Inference Pipeline
E
CI/CD for MLOps
Compound AI Systems
Context Window for LLMs
E
DAG Processing Model
Data Compatibility
Data Contract
Data Lakehouse
Data Leakage
Data Modeling
Data Partitioning
Data Pipelines
Data Quality
Data Transformation
Data Type (for features)
Data Validation (for features)
Data Warehouse
Data-Centric ML
Dimensional Modeling and Feature Stores
Downstream
Query Engines
E
ETL
Embedding
Encoding (for Features)
Entity
E
Feature
Feature Data
Feature Engineering
Feature Freshness
Feature Function
Feature Groups
Feature Logic
Feature Monitoring
Feature Pipeline
Feature Platform
Feature Reuse
Feature Selection
Feature Service
Feature Store
Feature Type
Feature Value
Feature Vector
Feature View
Filtering
Fine-Tuning LLMs
E
Generative AI
Gradient Accumulation
Grouped Query Attention
E
Hallucinations in LLMs
Hyperparameter
Hyperparameter Tuning
E
Idempotent Machine Learning Pipelines
In Context Learning (ICL)
Inference Data
Inference Logs
Inference Pipeline
Instruction Datasets for Fine-Tuning LLMs
E
LLM Code Interpreter
LLM Temperature
LLMOps
LLMs - Large Language Models
Lagged features
LangChain
Latent Space
E
ML
ML Artifacts (ML Assets)
MLOps
MLOps Platform
MVPS
Machine Learning Infrastructure
Machine Learning Logs
Machine Learning Observability
Machine Learning Pipeline
Machine Learning Systems
Model Architecture
Model Bias
Model Deployment
Model Development
Model Evaluation (Model Validation)
Model Governance
Model Inference
Model Interpretability
Model Monitoring
Model Performance
E
Natural Language Processing (NLP)
E
Offline Store
On-Demand Features
On-Demand Transformation
Online Inference Pipeline
Online Store
Online-Offline Feature Skew
Online-Offline Feature Store Consistency
Orchestration
E
KServe
PagedAttention
Pandas UDF
Parameter-Efficient Fine-Tuning (PEFT) of LLMs
Point-in-Time Correct Joins
Precomputed Features
Prompt Engineering
Prompt Store
Prompt Tuning
Python UDF
E
RLHF - Reinforcement Learning from Human Feedback
Real-Time Machine Learning
Recommender System
Representation Learning
Retrieval Augmented Generation (RAG) for LLMs
RoPE Scaling
E
SQL UDF in Python
Sample Packing
Schema
Similarity Search
Skew
Splitting Training Data
Streaming Feature Pipeline
Streaming Inference Pipeline
E
Test Set
Theory-of-Mind Tasks
Time travel (for features)
Train (Training) Set
Training Data
Training Pipeline
Training-Inference Skew
Transformation
Two-Tower Embedding Model
Types of Machine Learning
E
Upstream
E
Validation Set
Vector Database
Versioning (of ML Artifacts)
vLLM