SQL-Based vs Code-Based Transformations — Roadmap Step & Resources
Trade-offs between transforming in the warehouse versus in a pipeline
- Level: beginner
- Estimated time: 1 days
- Roadmap: ETL/ELT Pipeline Engineering
Before this step
Study resources
- Airbyte Documentation (Article) — Official documentation for Airbyte, a widely used open-source data ingestion platform. Background reading/viewing for: SQL-Based vs Code-Based Transformations.
- dbt Documentation (Article) — Official documentation on SQL-based transformation fundamentals. Relevant to: SQL-Based vs Code-Based Transformations.
Part of
- Transformation Fundamentals — section
- ETL/ELT Pipeline Engineering roadmap — the full learning path