Course contentsShow
← Data Science
Lesson 1820 of 2,14543. Data Pipelines and OrchestrationFree lesson

Trade-offs: When to Use ELT

Identify scenarios favoring ELT: raw data preservation, exploratory analysis, and schema-on-read flexibility.

Trade-offs: When to Use ELT

You'll learn when ELT's "load first, transform later" approach outperforms traditional ETL.

The ELT Sweet Spot

ELT shines when you need flexibility over pre-planned structure. Unlike ETL (where you transform before loading), ELT dumps raw data into your warehouse first, then transforms it as needed. This approach excels in three key scenarios:

1. Raw Data Preservation

When you're unsure which fields you'll need later, ELT acts like a digital archive. Imagine a research library that keeps every manuscript in its original form—you can always go back and reinterpret the source material. If your transformation logic changes or you discover new business questions, the untouched raw data is already sitting in your warehouse, ready for fresh analysis.

2. Exploratory Analysis

Data scientists love ELT because it supports discovery-driven workflows. You're not locked into predefined aggregations or filtered views. Instead, you can query the full, granular dataset interactively, spotting patterns that your original ETL pipeline might have aggregated away or filtered out entirely.

3. Schema-on-Read Flexibility

ELT embraces the "schema-on-read" philosophy: structure is applied when you query the data, not when you load it. This is perfect when data schemas evolve frequently (think JSON logs or API responses with optional fields). Your warehouse accepts messy, semi-structured data, and you define meaningful structure during SQL queries or transformations—using the modern cloud compute power you learned about in previous lessons.

When ELT Makes Sense

Choose ELT when storage is cheap (cloud warehouses), compute is elastic, and you need iterative, experimental access to complete historical data.

Key Takeaway: Use ELT when raw data preservation, exploratory workflows, and schema flexibility matter more than upfront transformation guarantees—modern cloud warehouses make this trade-off increasingly attractive.